Kamran Agayev's Oracle Blog

Oracle Certified Master

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:


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


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

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

  1. Punith kumar HM Says:

    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

  2. Kamran Agayev A. Says:

    Dear Punith
    Check the documentation :

  3. abdul Says:

    nice way to spread a knowledge

  4. Log Buffer #260, A Carnival of the Vanities for DBAs | The Pythian Blog Says:

    […] Kamran Agayev shares his take on Getting “ORA-00959: tablespace ‘TBS01? does not exist” during Data Pump import. […]

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>