Re: Error on export data

Hi,

Are you sure that you are using the correct export utility with the correct views. i.e. Running an Oracle7 v7.3.4 export with the views from the Oracle7 v7.3.4 catexp?.sql file.

If in doubt, login to the box and rerun the catexp?.sql file from $ORACLE_HOME/rdbms/admin directory, and then rerun your export.

Andrew

Yohannes A Sulistyono wrote:

> Hi Folks,
>
> I'm trying to export my oracle databse using command 'exp'.
> But I was encountering error as follows :
> -- start --
> About to export the entire database ...
> . exporting tablespace definitions
> . exporting profiles
> . exporting user definitions
> . exporting roles
> . exporting resource costs
> . exporting rollback segment definitions
> . exporting database links
> . exporting sequence numbers
> . exporting snapshots
> . exporting snapshot logs
> . exporting job queues
> EXP-00008: ORACLE error 900 encountered
> ORA-00900: invalid SQL statement
> EXP-00222:
> System error message 2
> EXP-00000: Export terminated unsuccessfully
> -- end --
>
> My question is how to run 'exp' using option 'ignore error'?
>
> TIA,
> _aries_
Received on Mon May 10 1999 - 07:46:30 CDT