开源中文网

您的位置: 首页 > 数据库应用 > Oracle > 正文

ORA-39125:错误

来源:  作者:

ORA-39125: 在 KUPW$WORKER.UNLOAD_METADATA 中 Worker 发生意外的致命错误 (在调用 DBMS_METADATA.FETCH_XML_CLOB [TABLE_STATISTICS] 时) 
ORA-22813: 操作数值超出系统的限制 
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105 
ORA-06512: 在 "SYS.KUPW$WORKER", line 6241 
----- PL/SQL Call Stack ----- 
object line object 
handle number name 
3BE8E064 14916 package body SYS.KUPW$WORKER 
3BE8E064 6300 package body SYS.KUPW$WORKER 
3BE8E064 2340 package body SYS.KUPW$WORKER 
3BE8E064 6861 package body SYS.KUPW$WORKER 
3BE8E064 1262 package body SYS.KUPW$WORKER 
5015A900 2 anonymous block 
作业 "SCOTT"."EXPDP_BJSX" 因致命错误于 13:21:45 停止 
原因 
DMSYS schema objects have been accidentally removed 
or 
Step 'DELETE from exppkgact$ WHERE SCHEMA='DMSYS'; ' from Note 297551.1 has not been performed 
Solution 
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

Tags:ORA-39125错误
相关文章列表:
关于开源中文网 - 联系我们 - 广告服务 - 网站地图 - 版权声明