taking database dumps automatically
793965Apr 8 2011 — edited Apr 8 2011hi 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...