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
问题解决!