Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

taking database dumps automatically

793965Apr 8 2011 — edited Apr 8 2011
hi gems...good afternoon..

i have three schemas. suppose the credentials aof the schemas are...

1. schema1/pass1@sid
2. schema2/pass2@sid
3. schema3/pass3@sid

now i take the dumps of those manually daily in my d drive by the following command from command prompt...

exp schema1/pass1@sid file=schema1_today'sdate.dmp log=schema1_today'sdate.log
exp schema2/pass2@sid file=schema2_today'sdate.dmp log=schema1_today'sdate.log
exp schema3/pass3@sid file=schema3_today'sdate.dmp log=schema1_today'sdate.log

now i want to make this task automated...means i will be out of station for several days, so i want in my absence the backup dumps should be taken automatically daily at 7pm.

is there any process to make a batch file by which i can achieve my goal???

please help...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2011
Added on Apr 8 2011
5 comments
193 views