2008/12/15

EXP-00056, ORA-31600

Database: 9.2.0.5
OS: Win2000 SP4

Export of this 9i database fails with:

EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in
function SET_TRANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050
ORA-06512: at "SYS.DBMS_METADATA", line 836
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully


Solution:

Connect as sys and run the following script:

SQL> @$ORACLE_HOME/rdbms/admin/catmeta.sql

No comments: