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 -> Error on export data

Error on export data

From: Yohannes A Sulistyono <aries_at_idola.net.id>
Date: Mon, 10 May 1999 18:51:41 +0700
Message-ID: <7h82kp$sb72@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 - 06:51:41 CDT

Original text of this message

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