Impdp With TABLE_EXISTS_ACTION as "REPLACE" Does Not Generate An Entry In The Recyclebin (Doc ID 1990614.1)

Last updated on MARCH 26, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

An import was performed on a wrong table in the target database and the data from the original table got removed.
The table data could not be found in the recycle bin (parameter 'recyclebin' is set to 'on') and when trying to recover the data from the undo, next error was encountered:

ORA-01466: unable to read data - table definition has changed


Note that impdp was performed with parameter TABLE_EXISTS_ACTION=REPLACE

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms