我每天晚上做次expdp导出数据。一直都好好的。但从上星期六开始不能正常导出数据了。报错如下Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 6.638 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [TABLE_STATISTICS]
ORA-44203: timeout waiting for lock on cursorORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001----- PL/SQL Call Stack -----
object line object
handle number name
7000000e14d5a38 20462 package body SYS.KUPW$WORKER
7000000e14d5a38 9028 package body SYS.KUPW$WORKER
7000000e14d5a38 10935 package body SYS.KUPW$WORKER
7000000e14d5a38 2728 package body SYS.KUPW$WORKER
7000000e14d5a38 9697 package body SYS.KUPW$WORKER
7000000e14d5a38 1775 package body SYS.KUPW$WORKER
7000000ab9d8f70 2 anonymous block
求教 这个是怎么了呢 刚才用EXp好像能 正常导出的
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 6.638 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [TABLE_STATISTICS]
ORA-44203: timeout waiting for lock on cursorORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001----- PL/SQL Call Stack -----
object line object
handle number name
7000000e14d5a38 20462 package body SYS.KUPW$WORKER
7000000e14d5a38 9028 package body SYS.KUPW$WORKER
7000000e14d5a38 10935 package body SYS.KUPW$WORKER
7000000e14d5a38 2728 package body SYS.KUPW$WORKER
7000000e14d5a38 9697 package body SYS.KUPW$WORKER
7000000e14d5a38 1775 package body SYS.KUPW$WORKER
7000000ab9d8f70 2 anonymous block
求教 这个是怎么了呢 刚才用EXp好像能 正常导出的
解决方案 »
- Oracle 简单存储过程! 就一条select语句!
- 求一个sql语句
- 求助,ORACLE能否获得近3个月的SQL操作日志?
- 关于数据操作中并发的问题
- 请教一个在修改记录时出现的关于表空间的错误怎么解决?
- 在个人pc机上装Oracle 9i能行么?我的是赛扬1.7 内存512m
- 帮我看看这个函数创建时为什么出错
- 请问学习oracle9i 的sqlplus是否能使用oracle 8 的书?
- 请教:dp2K如何通过odbc操作异质数据库如sqlserver?
- Ora-00366 error occurs when running a long batch
- oracle11g SQLLDR闪退
- 为什么会出现missing vlaues keyword?
ORA-44203: timeout waiting for lock on cursor