作者:guoge
E:>exp system/manager file=backbill.dmp owner=backbill
Export: Release 9.2.0.4.0 - Production on Thu Nov 18 14:42:11 2004
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 US7ASCII 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 BACKBILL
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user BACKBILL
About to export BACKBILL'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_TR
ANSFORM_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
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user BACKBILL
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user BACKBILL
About to export BACKBILL'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_TR
ANSFORM_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
出现这个问题我也不知道应该怪我还是怪Oracle。其实这个问题原因和解决方法很简单。
我是先安装oracle9.0.2.1,然后安装9.0.2.4补丁,再创建数据库,我以为这样在创建数据库时就会执行9.0.2.4的脚本,也就没看补丁的README。
其实文档里要求在安装补丁之后,再执行catpatch.sql脚本。
当然上面的问题解决也很简单,就是执行catpatch.sql脚本就可以了。具体过程如下:
1. shutdown immedaite
2. startup migrate
3 @ ?rdbmsadmincatpatch
4. shutdown immedaite
5. startup
需要说明的是: 这种ORA-31600问题只有在给数据库打补丁时才会出现,不打补丁的9i不会出现。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/166555/viewspace-787162/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/166555/viewspace-787162/