Hello Experts
I am trying do a datapump and I get the error as given below. I tried to use the EXCLUDE=STATISTICS clause, but still I get the same error. Please guide me to move forward.
Export: Release 11.2.0.1.0 - Production on Thu Nov 14 13:28:36 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Starting "test"."SYS_EXPORT_SCHEMA_05": test/********@mydb schemas=my_schema directory=DATAPUMP dumpfile=dev_my_schema_DB_11_14_2013.dp logfile=dev_my_schema_DB_11_14_2013.log FLASHBACK_TIME=SYSTIMESTAMP
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3.226 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/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [SEQUENCE:"my_schema"."my_schema_ID_SEQ"]
ORA-44203: timeout waiting for lock on cursor
ORA-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
0xf7388d08 20462 package body SYS.KUPW$WORKER
0xf7388d08 9028 package body SYS.KUPW$WORKER
0xf7388d08 10935 package body SYS.KUPW$WORKER
0xf7388d08 2728 package body SYS.KUPW$WORKER
0xf7388d08 9697 package body SYS.KUPW$WORKER
0xf7388d08 1775 package body SYS.KUPW$WORKER
0x16bd96fe8 2 anonymous block
Job "test"."SYS_EXPORT_SCHEMA_05" stopped due to fatal error at 13:35:50