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:

[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

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
    punith

  2. abdul Says:

    nice way to spread a knowledge

  3. 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. [...]

  4. Kamran Agayev A. Says:

    Dear Punith
    Check the documentation :
    http://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#i13546

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=""> <strike> <strong>