OraFAQ Forum: Server Utilities » How to Check For Successful Exp/Imp

Home » RDBMS Server » Server Utilities » How to Check For Successful Exp/Imp

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Check For Successful Exp/Imp [message #72617]

Mon, 04 August 2003 11:05

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

Report message to a moderator

Re: How to Check For Successful Exp/Imp [message #72618 is a reply to message #72617]

Mon, 04 August 2003 13:04

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: How to Check For Successful Exp/Imp [message #314387 is a reply to message #72617]

Wed, 16 April 2008 09:23

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

Michel Cadot
Messages: 68652
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

Report message to a moderator

Previous Topic:	IMP-00017 error
Next Topic:	Full Import error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 04:32:49 CDT 2024