My Oracle Support Banner

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 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:

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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.