DBA GENESIS
Courses
Contact
Members
More
how to be write batch file for exp and imp with day and time
Yes, par file is compatible with oracle 10g.
To use a par file in Windows, change your directory to the location of the par file and run the expdp command.
for example:
expdp username/password parfile=parfilename.par
I guess you mean PAR file for backup, here is a link that describes how to write PAR file for expdp / impdp:
https://www.support.dbagenesis.com/post/oracle-data-pump-expdp-impdp#viewer-dgd0g
For scheduling the exports and imports, you can modify below RMAN scheduling script to achieve same: https://www.support.dbagenesis.com/post/automate-rman-backups-using-shell-scripts
https://www.lifewire.com/bat-file-2619796#:~:text=A%20file%20with%20the%20.,of%20scripts%20one%20after%20another.
https://docs.oracle.com/database/121/SUTIL/GUID-7A045C82-5993-44EB-AFAD-B7D39C34BCCD.htm#SUTIL859
@Arun Kumar
when I run this bar file . it show me this error
par file is Compatible with 10g ? due to I used oracle database 10g
Yes, par file is compatible with oracle 10g.
To use a par file in Windows, change your directory to the location of the par file and run the expdp command.
for example:
expdp username/password parfile=parfilename.parI guess you mean PAR file for backup, here is a link that describes how to write PAR file for expdp / impdp:
https://www.support.dbagenesis.com/post/oracle-data-pump-expdp-impdp#viewer-dgd0g
For scheduling the exports and imports, you can modify below RMAN scheduling script to achieve same: https://www.support.dbagenesis.com/post/automate-rman-backups-using-shell-scripts