Re: Success of Export

Sameer Utrankar wrote:
>
> I wish to export with compress, drop and import to get rid of multiple
> extents. I want to do this at night when I will not be around to find
> out the sucess of export before dropping it and am scared to do this
> on a production database.
>
> My concern is exp return code ($status or $? for csh or ksh) does not
> seem to be too reliable. I have found cases where it is 0 even when
> export terminates with warnings.
>
> Redirecting output of exp command and then grep for ORA- is one way.
> Seems crude though.
>
> The sure way could be counting the number of rows in the table and
> comparing that with NUMBER OF ROWS IN EXPORT FILE (if there is such a
> thing). Does anybody know if I can scan .dmp (strings, grep
> anything..) to find number of rows exported for a particular table ?
> (assume a simple case of only one table export per .dmp file).
>
> Any other guranteed ways to check success of exp before drop table ?
> --------------------------------------------
> Utrankas_at_coned.com (Sameer Utrankar)

The easiest way I have found is to create a log file for the export with the log= parameter.
I then grep for "Export terminated successfully without warnings." in this log file.

Hope this helps.

Sean Walters DBA Received on Tue Apr 23 1996 - 00:00:00 CEST