ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXP错误

EXP错误

原创 Linux操作系统 作者:fjmingyang 时间:2019-06-08 08:33:06 0 删除 编辑

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

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


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

解决办法如下:

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

@%ORACLE_HOME%rdbmsadmincatmeta.sql

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/1698901/viewspace-103284/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2006-04-03

  • 博文量
    66
  • 访问量
    48420