Import of Partitioned Table/Constraint Fails With Error ORA-959 Tablespace _$Deleted$0$0 When Partitions/Indexes Had Once Been Moved To Another Tablespace
(Doc ID 1593166.1)
Last updated on SEPTEMBER 26, 2019
Applies to:Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
You are trying to import a partition table into another database using data pump import (IMPDP) and it fails with the following errors like in the following example:
ORA-39083: Object type TABLE:"<SCHEMA>"."<TABLE_NAME>" 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.
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