ORA-31693 ORA-01466 Error When Executing Expdp

Executing an expdp at work I got the next output;

 
ORA-31693: Table data object "REPORT_BW"."TRAC_ACTIVITY" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01466: unable to read data - table definition has changed

 

The problem is a bug, if you have access to ML/MOS, please take a look at 1072871.1 note. The possible solutions are;

  • Upgrade to 12c
  • Apply patchset 11.2.0.3
  • Apply interim Patch 9110642
  • Don’t use FLASHBACK_SCN or FLASHBACK_TIME

HTH – Antonio NAVARRO

 

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