Kamran Agayev's Oracle Blog

Oracle Certified Master

Archive for February 14th, 2012

Getting “ORA-00959: tablespace ‘TBS01’ does not exist” during Data Pump import

Posted by Kamran Agayev A. on 14th February 2012

When importing data from different database, sometimes you get errors like:

[php]

ORA-39083: Object type TABLESPACE_QUOTA failed to create with error:
ORA-00959: tablespace ‘TBS01’ does not exist
Failing sql is:

[/php]

This means that the tablespace “TBS01” doesn’t exist in the database where you’re importing the data. For this, you can use REMAP_TABLESPACE option. If you have more than one tablespace that doesn’t exist in the second database, use comma as follows:

[php]REMAP_TABLESPACE=db01_tbs01:db02_tbs,db_01_tbs02:db02_tbs [/php]

 

To get which remap script you need to create, check TABLESPACE_NAME column for the DBA_SEGMENTS view and find in which tablespaces your objects are reside

Posted in Administration | 4 Comments »