ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM.

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

Example:

Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEEDEV
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEEDEV
About to export TEEDEV's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRAN SFORM_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

Cause:

View the readme notes for the patchset recently installed. You will see a step that should have been performed that directs you to run the script named catpatch.sql. Very likely this step was never performed.

Fix:

As the sysdba user run the catpatch.sql script found in the directory named $ORACLE_HOME/rdbms/admin. Before you submit this script, view it's contents. You may see that this script places the database in restricted mode.