ORA-31693: Table data object “schema”.”table” failed to load/unload and is being skipped due to error:

I often get ORA-31693 when doing DataPump imports. The error can be caused by a lot of things and the solution is to fix the underlying problem and re-import the table. It’s time consuming to sift through hundreds of lines in an import log file to find the skipped tables so I use this script which generates a list of tables that I can include in the next import script’s ‘TABLES=’ parameter.

cat import.log | grep failed | awk '{ print $5 }' | sed s/\"//g |  awk '{ print $1 " ,"}'

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s