190 pts.
 I need help with how to programmatically backup a database
I’m trying to programmatically backup a database using the following command:
expdp system/system_password
directory=dir_exp job_name=jobexp
SCHEMAS=my_schema
where "system_password" is the actual "system" password and "my_schema" is the name of the schema I want to export. How can I verify in an automatic manner that the export was successful? Searching the log file for the "successfully completed at" line is not such a good idea... The question remains for restore also: how can I check that the restore is successful?

Software/Hardware used:
ASKED: April 28, 2008  2:10 PM
UPDATED: April 29, 2008  7:44 PM

Answer Wiki:
read the log file is the unique way to verify wheter the export was successfull or not. You can write a second script to read the log file.
Last Wiki Answer Submitted:  April 29, 2008  7:44 pm  by  Xclaudealain   45 pts.
All Answer Wiki Contributors:  Xclaudealain   45 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _