With Oracle 10g onwards, you can create a dbms_scheduler task to run your nightly exports and hot backups, without the need for using cron jobs, in Linux and Solaris environments. Please note that this also applies to Windows environments as well.
To start off create the Scheduler Program:
You don’t need to add any arguments to the Scheduler Program, as the shell script full_exp_script.sh will contain all the required arguments.
Next, create the Job:
Then create the Job Schedule:
Create the Job options, if any:
This completes the setup of the scheduler task in Oracle. Now you need to create the shell script for the export, which is called as an external program.
Use the following script:
You may customise it based on your requirements. I added the .bash_profile since I had problems executing the exp, executable. I also added the LD_LIBRARY_PATH as it refused to execute with errors of missing ld libraries.
Let me know if you have any issues.
1 comment:
Export Scheduler data via iCalendar
Post a Comment