oracle  exp ORA-31600和ORA-00942问题的解决
在不同版本的Oracle之间Exp导出时，出现ORA-00942错误．

连接到: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
即将导出指定的用户...
. 正在导出 pre-schema 过程对象和操作
. 正在导出用户 NORMALSOFT 的外部函数库名称
. 导出 NORMALSOFT 类型同义词
. 导出私有类型同义词
. 正在导出用户 NORMALSOFT 的对象类型定义
EXP-00008: 遇到 ORACLE 错误 942
ORA-00942: 表或视图不存在
EXP-00024: 未导出视图，请通知您的 DBA
EXP-00000: 导出终止失败

上网检索后发现由于数据库打补丁后没有更新ＥＸＰ数据字典所致，更新catexp.sql.

sqlplus /nolog
connect / as sysdba;
@$ORACLE_HOME/rdbms/admin/catexp.sql

再次执行导出出现下面ORA-31600错误提示:
连接到: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集

即将导出指定的用户...
. 正在导出 pre-schema 过程对象和操作
. 正在导出用户 NORMALSOFT 的外部函数库名称
. 导出 NORMALSOFT 类型同义词
. 导出私有类型同义词
. 正在导出用户 NORMALSOFT 的对象类型定义
即将导出 NORMALSOFT 的对象 ...
. 正在导出数据库链接
. 正在导出序号
. 正在导出群集定义
EXP-00056: 遇到 ORACLE 错误 31600
ORA-31600: 输入值 EMIT_SCHEMA 无效, 它用于参数 NAME, 位于函数 SET_TRANSFORM_PARAM 中
ORA-06512: 在"SYS.DBMS_SYS_ERROR", line 105
ORA-06512: 在"SYS.DBMS_METADATA_INT", line 3926
ORA-06512: 在"SYS.DBMS_METADATA_INT", line 4050
ORA-06512: 在"SYS.DBMS_METADATA", line 836
ORA-06512: 在line 1
EXP-00000: 导出终止失败

检查后发现忘记安装catpatch.sql更新数据字典.
sqlplus /nolog
shutdown immediate;
startup migrate;
@$ORACLE_HOME/rdbms/admin/catpatch.sql;
shutdown immediate;
startup;
再次导出，问题解决．

----------------------------------------------------------------------------------------------------

主题: Bug 3591564 - ORA-1756 importing functional index with CHR(0) in its expression
文档 ID: 3591564.8 类型: PATCH
上次修订日期: 24-SEP-2008 状态: PUBLISHED

Bug 3591564 ORA-1756 importing functional index with CHR(0) in its expression
This note gives a brief overview of bug 3591564.
The content was last updated on: 10-OCT-2005
Click here for details of each of the sections below.

Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions < 10.2
Versions confirmed as being affected 9.2.0.4
10.1.0.3

Platforms affected Generic (all / most platforms affected)

The fix for this bug introduces a notable change in behaviour thus:
Notable change of behaviour introduced in 9.2.0.7

Fixed:
This issue is fixed in 9.2.0.7 (Server Patch Set)
10.1.0.4 (Server Patch Set)
10.2.0.1 (Base Release)


Symptoms: Related To:
Error May Occur
ORA-1756
Export/Import
Function Based Index (Including DESC Indexes)


Description
If a functional index having chr(0) in its expression is exported,
upon import while executing the create index statement import fails
with an ORA-1756.


Note:
This fix adds a server side function used by client side export.
As such using a CLIENT with this fix against a SERVER without
the fixed export packages results will result in errors at
export time such as:
EXP-00056: ORACLE error 904 encountered
ORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifier

Hence this fix is needed at both the client and server sides to be
effective.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.


References
Bug 3591564 (This link will only work for PUBLISHED bugs)
Note 245840.1 Information on the sections in this article