impdp failed to import one table, while succeeding on all the other tables
Hi,
I tried to import a schema from a full export dmp file using impdp. The job consistently hang with one of the tables. None of the 200 million rows is imported, whether the table is impted from a list of tables or as the only table. Waiting for hours but there is no further progress. when it hang, this is the status of the job:
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: CLARITY
Object Name: F_MU_OBJECTIVE
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 1
Completed Bytes: 4,180,683,208
Worker Parallelism: 1
No errors
when I kill the job and check row counts, there is none.
I tried to import a schema from a full export dmp file using impdp. The job consistently hang with one of the tables. None of the 200 million rows is imported, whether the table is impted from a list of tables or as the only table. Waiting for hours but there is no further progress. when it hang, this is the status of the job:
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: CLARITY
Object Name: F_MU_OBJECTIVE
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 1
Completed Bytes: 4,180,683,208
Worker Parallelism: 1
No errors
when I kill the job and check row counts, there is none.
0