ORACLE exp - EXP-00056: ORACLE error 600 encountered

[Stephen Badgett]

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

[TwoProc]

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...

[Patti Johnson · Accepted solution]

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]

Patti --

that was perfect thank you

[Stephen Badgett]

Patti Johnson - fixed it