My Oracle Support Banner

Import Partitioned Table Fails With Error ORA-959 Tablespace _$Deleted$0$0 (Doc ID 798142.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Oct-2013***

Symptoms

Trying to import a partitioned table into another database using impdp/imp fails and received the following error:

ORA-39083: Object type TABLE failed to create with error:
ORA-00959: tablespace '_$deleted$0$0' does not exist

 

Note:
_$deleted$0$0 could be  _$deleted$<n>$0

Changes

All the table partitions had once been moved to another tablespace and the original tablespace has now been dropped or the new tablespace where partitions now reside has been renamed to the original tablespace name.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.