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 »