Home » RDBMS Server » Server Utilities » How to Check For Successful Exp/Imp
How to Check For Successful Exp/Imp [message #72617] Mon, 04 August 2003 11:05 Go to next message
Michele
Messages: 77
Registered: December 2000
Member
Hello Everyone,

I have created a cron job on my Solaris box that calls a script that is coded to run the exp and import utility. I am exporting 2 tables and importing them on a weekly basis.
How do I check if the export was successful or has data? Is there a number that is returned that tells me if it was successful and had no errors?
Or do I code commands in the cron to see if the cron ran successfully?

Any help will be appreciated..

Thanks
Michele
Re: How to Check For Successful Exp/Imp [message #72618 is a reply to message #72617] Mon, 04 August 2003 13:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
if you can use log=somelogfile.log option alongwith exp/imp commands,
the log file will be created.
you can grep the logifle for errors and if errors found you send an email~!
or
just email the logfile

Re: How to Check For Successful Exp/Imp [message #314387 is a reply to message #72617] Wed, 16 April 2008 09:23 Go to previous messageGo to next message
cf29663
Messages: 1
Registered: April 2008
Junior Member
Hi,
I encountered the same problem: how can you check the export/import programmatically?
Searching for
"successfully completed at"
or specific strings in the log might not be such a good idea because of the localization issues. For a french machine, this message will be
"exécuté avec succès à "

thanks,
Flavius

[Updated on: Wed, 16 April 2008 10:08] by Moderator

Report message to a moderator

Re: How to Check For Successful Exp/Imp [message #314395 is a reply to message #314387] Wed, 16 April 2008 10:09 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Set your NLS_LANGUAGE to american before exporting/importing then your message will always be the same one.

Regards
Michel
Previous Topic: IMP-00017 error
Next Topic: Full Import error
Goto Forum:
  


Current Time: Wed Dec 07 08:48:49 CST 2016

Total time taken to generate the page: 0.07489 seconds