Thursday, November 29, 2007

Automatic Oracle 10g export using cron job.

Hi,
Today, I want to share shell script and steps for automatic export using Oracle 10g datapump.
As Oracle says that datapump is fater than imp/exp 45%. and I admit as I experienced it.
Agenda: automatic export (Oracle says it "logical backup") On Unix/Linux Machine.
Steps:
1. Make directory in oracle (it is mendatory for impdp/expdp).
2. Give read, write privileges on directoy to user.
3. Shell script.
4. Configurations.

1.
connect to oracle as "as sysdba"


I will complete it on monday hopefully....

No comments: