Impdp With TABLE_EXISTS_ACTION as "REPLACE" Does Not Generate An Entry In The Recyclebin
Last updated on MARCH 26, 2015
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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:
Note that impdp was performed with parameter TABLE_EXISTS_ACTION=REPLACE
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