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 " ,"}'
Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s