Import of Partitioned Table/Constraint Fails With Error ORA-959 Tablespace _$Deleted$0$0 When Partitions/Indexes Had Once Been Moved To Another Tablespace
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
Trying to import a partition table into another database using impdp/imp fails with the following error:
ORA-39083: Object type TABLE:"AUTO"."DWH_AUTO_ROE_DEALER_SUMMARY" failed to create with error:
ORA-00959: tablespace '_$deleted$557$0' does not exist"
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-00959: tablespace '_$deleted$556$0' does not exist
All the table partitions had once been moved to another tablespace and the original tablespace has now been dropped or the new tablespace where the partitions now reside has been renamed to the original tablespace name.
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