oracle 11.2.0.3 expdp 时报错，PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared

$ expdp system/system full=y directory=EXPDPIMPDP2 dumpfile=20170819_%U.dmp parallel=4 job_name=expimpdp

Export: Release 11.2.0.3.0 - Production on Sat Aug 19 02:10:19 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting “SYSTEM”.”EXPIMPDP”: system/** full=y directory=EXPDPIMPDP2 dumpfile=20170819_%U.dmp parallel=4 job_name=expimpdp
Estimate in progress using BLOCKS method…
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN “DMSYS”.”DBMS_DM_MODEL_EXP”.SCHEMA_CALLOUT(:1,0,1,’11.02.00.00.00’); END;
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.DBMS_METADATA”, line 1749
ORA-06550: line 1, column 8:
PLS-00201: identifier ‘DMSYS.DBMS_DM_MODEL_EXP’ must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.KUPW$WORKER”, line 8996
重点内容

—– PL/SQL Call Stack —–
object line object
handle number name
0x8bc99b38 20462 package body SYS.KUPW$WORKER
0x8bc99b38 9028 package body SYS.KUPW$WORKER
0x8bc99b38 10935 package body SYS.KUPW$WORKER
0x8bc99b38 13698 package body SYS.KUPW$WORKER
0x8bc99b38 2654 package body SYS.KUPW$WORKER
0x8bc99b38 9697 package body SYS.KUPW$WORKER
0x8bc99b38 1775 package body SYS.KUPW$WORKER
0x8bf236a8 2 anonymous block

Estimate in progress using BLOCKS method…
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN “DMSYS”.”DBMS_DM_MODEL_EXP”.SCHEMA_CALLOUT(:1,0,1,’11.02.00.00.00’); END;
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.DBMS_METADATA”, line 1749
ORA-06550: line 1, column 8:
PLS-00201: identifier ‘DMSYS.DBMS_DM_MODEL_EXP’ must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.KUPW$WORKER”, line 8996

—– PL/SQL Call Stack —–
object line object
handle number name
0x8bc99b38 20462 package body SYS.KUPW$WORKER
0x8bc99b38 9028 package body SYS.KUPW$WORKER
0x8bc99b38 10935 package body SYS.KUPW$WORKER
0x8bc99b38 13698 package body SYS.KUPW$WORKER
0x8bc99b38 2654 package body SYS.KUPW$WORKER
0x8bc99b38 9697 package body SYS.KUPW$WORKER
0x8bc99b38 1775 package body SYS.KUPW$WORKER
0x8bf236a8 2 anonymous block

Job “SYSTEM”.”EXPIMPDP” stopped due to fatal error at 02:11:40

这个问题是需要 重建dmsys用户
SQL> drop user dmsys cascade;
SQL> @？/rdbms/admin/dminst.sql SYSAUX TEMP $ORACLE_HOME/rdbms/admin/
SQL> @？/rdbms/admin/odmpatch.sql
SQL> @？/rdbms/admin/utlrp.sql
SQL> select COMP_NAME,VERSION,STATUS from dba_registry where COMP_NAME=’Oracle Data Mining’;

SQL> create synonym DMSYS.DBMS_DM_MODEL_EXP for SYS.DBMS_DM_MODEL_EXP;

转载于:https://www.cnblogs.com/ctypyb2002/p/9793112.html