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)