Impdp With TABLE_EXISTS_ACTION as "REPLACE" Does Not Generate An Entry In The Recyclebin
(Doc ID 1990614.1)
Last updated on SEPTEMBER 25, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document