EXP错误

最新推荐文章于 2024-09-29 16:19:38 发布

clfbn64004

最新推荐文章于 2024-09-29 16:19:38 发布

阅读量211

点赞数

文章标签：数据库

C:Documents and Settingsmingyang_chen>exp userid=cmy/cmy file=g:test.dmp log=
g:test.log rows=n indexes=y direct=y recordlength=65535

遇到如下错误>>

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user STIUSER5
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user STIUSER5
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully

解决办法如下：

用sys身份运行下catexp.sql脚本

@ %ORACLE_HOME%rdbmsadmincatexp.sql

Export: Release 9.2.0.6.0 - Production on Fri Nov 2 10:43:57 2007

Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CMY
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CMY
About to export CMY'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