Oracle Export: ORA-31600: Invalid EMIT_SCHEMA input value for NAME parameter in SET_TRANSFORM_PARAM function
I am trying to export a .dmp of an oracle database but I am getting the following error when running exp command
ORA-31600: invalid input EMIT_SCHEMA for parameter NAME in SET_TRANSFORM_PARAM function
This is the first time I have tried to export from this server since its inception. Is there something I need to do in order for the export to work correctly.
COMPLETE SOLUTION FOR ME (WINDOWS MACHINE)
1) Open command prompt at C: \ Oracle \ Ora92 \ rdbms \ admin
2) Login to sqlplus as sysdba, to do it in command line, you need to execute sqlplus "sys as sysdba"
3) Run catexp.sql - this will save you some errors (to run, type @@ catexp.sql on the command line)
4) Run catproc.sql
5) Run catmeta.sql, this requires shutting down oracle, run the patch and restart as described below.
1) logon sqlpus sysdba 2) close immediately; 3) start migration; 4) @@ catpatch.sql; 5) shutdown immediately; 6) Launch;
a source to share
Which version of Oracle are you using? Version 9.2 has the following issue if the hotfix is not applied properly:
Symptom(s)
~~~~~~~~~~
You are performing a database export against your 9.2 database. The database
export abnormally ends with the following errors:
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
This is detailed in Metalink document ID 257986.1.
If you are not using RAC, the fix should run /rdbms/admin/catpatch.sql. The likely cause is an incompletely applied patch set. You may need to be in restricted mode.
a source to share