Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using Oracle export utility (exp)

Re: Using Oracle export utility (exp)

From: Slarti <1012-873_at_gmx.de>
Date: 16 Jan 2002 23:15:25 -0800
Message-ID: <ccb8e3b6.0201162315.ce2340a@posting.google.com>


tferrazz_at_hotmail.com (Tony Ferrazzo) wrote in message news:<b12473a5.0201161500.6f2064b2_at_posting.google.com>...
> Hi,
> I am using exp with its many wonderful switches to do table
> maintenance. I am using a unix shell script which will be setup to run
> as a cron job. My question is:
>
> The exp utility does not seem to give any indication of success or
> failure, for example, I deliberately ran the script to exp a non
> existant table. The log showed the exp utility reporting the table did
> not exist but then went on to say the "Export terminated successfully
> without warnings." A unix check with $? always returns a 0 indicating
> success. AS we want to exp tables, drop them and then import them
> back, we need to be 100% sure the exp did in fact work.
>
> Hopefully someone can provide some ideas or assistance with this
> issue.
>
> Thanks in advance
>
> Tony Ferrazzo

If you need to be sure 100%, do a grep or find or anything else (if you want to get only unique messages combine with a "sort -u"). You will have to check the imp-/exp-logfiles for occurence of "IMP-" respective "EXP-".
Or just take a look on these files. Received on Thu Jan 17 2002 - 01:15:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US