Getting “ORA-00959: tablespace ‘TBS01’ does not exist” during Data Pump import
Posted by Kamran Agayev A. on February 14th, 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
February 15th, 2012 at 4:36 am
hi sir …
I wan’t to know about how to gather statestics and where that gatherd information will store…what is use from that…?
Thank u sir
punith
February 24th, 2012 at 6:14 am
Dear Punith
Check the documentation :
http://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#i13546
February 15th, 2012 at 4:11 pm
nice way to spread a knowledge
February 24th, 2012 at 6:01 am
[…] Kamran Agayev shares his take on Getting “ORA-00959: tablespace ‘TBS01? does not exist” during Data Pump import. […]