Exp出这个错

Exp出这个错PLS-00201: 必须宣告识别项 'DMSYS.DBMS_DM_MODEL_EXP'

即将汇出设定的使用者 ...

. 正在汇出预先纲要程序对象与动作

EXP-00008: ORACLE 错误 6550 发生

ORA-06550: 第 1 行, 第 13 个字段: 

PLS-00201: 必须宣告识别项 'DMSYS.DBMS_DM_MODEL_EXP'

ORA-06550: 第 1 行, 第 7 个字段: 

PL/SQL: Statement ignored

EXP-00083: 当呼叫 DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp 时发生了先前的问题

怎么去创建DMSYS.DBMS_DM_MODEL_EXP

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

catalog first, then catproc, then catexp

it is ok for the err prompt  

If DMSYS has already been dropped

Start SQLPLUS and connect with user SYS as SYSDBA 

SQL> DELETE FROM exppkgact$ WHERE SCHEMA='DMSYS'; 

SQL> exit; 

proceed with export jobs

If dmsys schema objects have been accidentally removed

set ORACLE_HOME and ORACLE_SID 

Start SQLPLUS and connect with user SYS as SYSDBA 

SQL> run $ORACLE_HOME/dm/admin/dminst.sql SYSAUX TEMP $ORACLE_HOME/dm/admin/ 

SQL> run $ORACLE_HOME/dm/admin/odmpatch.sql (if the database is at 10g patch level, e.g. 10.1.0.3 or 10.1.0.4) 

SQL> run $ORACLE_HOME/rdbms/admin/utlrp.sql 

Ensure 'Oracle Data Mining' is at Valid status in dba_registry 

SQL> select COMP_NAME,VERSION,STATUS from dba_registry where COMP_NAME='Oracle Data Mining'; 

proceed with export jobs

==========================================>>>

解决Oracle导出时的 SYS.LT_EXPORT_PKG 错误

执行exp命令时报错： ORA-06550: line 1, column 13: PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_

执行 Select * From Dba_Objects Where owner='SYS' And object_name Like 'LT_%' 发现LT_EXPORT_PKG编译不通过，

经过三番五次的折腾，

最后发现执行脚本 oracle\product\10.2.0\db_1\RDBMS\ADMIN\owminst.plb ，问题全解决了。

==========================================>>>

出现问题如下：

ORA-39127: unexpected error from call to export_string :=EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp('HNMJSYS',1,1,'10.02.00.01.00',newblock)

ORA-06550: line 1, column 12:

PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

ORA-06512: at "SYS.DBMS_METADATA", line 5419

ORA-39127: unexpected error from call to export_string :=EXFSYS.DBMS_EXPFIL_DEPASEXP.schema_info_exp('HNMJPRIV',1,1,'10.02.00.01.00',newblock)

ORA-06550: line 1, column 12:

PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

ORA-06512: at "SYS.DBMS_METADATA", line 5419

上METALINK上查看了一下

出现这个错误有两种原因：

1、用户EXFSYS用户事物处于无效状态

2、用户EXFSYS用户的事物被删除

通过select username,user_id from dba_users where username='EXFSYS';

查无此用户

解决方法：

1、Start SQLPlus.

2、Connect with user SYS as SYSDBA and issue the following commands:

SQL>DELETE FROM exppkgact$ WHERE SCHEMA='EXFSYS';

SQL>EXIT 

问题解决！