Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

ORACLE exp - EXP-00056: ORACLE error 600 encountered

SOLVED
Go to solution
Stephen Badgett
Regular Advisor

ORACLE exp - EXP-00056: ORACLE error 600 encountered

We are trying to expert a schema and we get this error ....

exp reg/fhg25d file=/tmp/reg.dmp

Export: Release 9.2.0.4.0 - Production on Mon Feb 20 12:23:52 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user REG
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user REG
About to export REG's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [], []
ORA-19206: Invalid value for query or REF CURSOR parameter
EXP-00000: Export terminated unsuccessfully
Not as is, is now
4 REPLIES
TwoProc
Honored Contributor

Re: ORACLE exp - EXP-00056: ORACLE error 600 encountered

If I remember this one correctly (pardon if I don't)...

See if you have any triggers named the same as other database objects. If so, rename the triggers.

My memory is not hitting me strongly on this one, so if I'm wrong, sorry about that. But, this is pretty easy to check for...
We are the people our parents warned us about --Jimmy Buffett
Patti Johnson
Respected Contributor
Solution

Re: ORACLE exp - EXP-00056: ORACLE error 600 encountered

Steve,

Take a look at Metalink Note:206313.1.

Looks like the solution is to run $ORACLE_HOME/rdbms/admin/catmeta.sql

Patti
Stephen Badgett
Regular Advisor

Re: ORACLE exp - EXP-00056: ORACLE error 600 encountered

Patti --

that was perfect thank you
Not as is, is now
Stephen Badgett
Regular Advisor

Re: ORACLE exp - EXP-00056: ORACLE error 600 encountered

Patti Johnson - fixed it
Not as is, is now