Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to troubleshoot impdp?

Aaron L.Feb 20 2022

My impdp stops at the same spot and never finishes. 3 tries and it stops after the same table each time. Is there a way to tell which table (object) it is having issues with?
Here is a sample of where it stops (changed the schema and tables for privacy). I'm assuming "table_three" is causing some issues, but I'm not sure how to see what that is.

W-1 . . imported "SCHEMA_NAME"."TABLE_ZERO"           0 KB    0 rows in 0 seconds using direct_path
W-3 . . imported "SCHEMA_NAME"."TABLE_ONE"          4.418 GB 51182229 rows in 465 seconds using direct_path
W-4 . . imported "SCHEMA_NAME"."TABLE_TWO"          10.55 GB 110373229 rows in 978 seconds using direct_path

When I run the "top" Linux command, it isn't even trying to finish. No errors, no messages, no processes running - it just sits there like it is dead. It runs a good couple hours before giving up after TABLE_TWO.
On Linux OCI 19c.

Comments
Post Details
Added on Feb 20 2022
6 comments
1,431 views