Re: Error on export data

Hi Yohannes,

The export views change with about every release. It is quite probable they are out of date in your database.
Could you please run $ORACLE_HOME/rdbms/admin/catexp.sql as sys via svrmgrl (on NT this is %ORACLE_HOME%\rdbms<nn>\admin\catexp.sql as sys via svrmrg<nn> where nn is the version number.

Hth,

Sybrand Bakker, Oracle DBA

Yohannes A Sulistyono wrote in message <7h82kp$sb72_at_indo-news>...
>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 - 11:46:56 CDT