Kamran Agayev's Oracle Blog

Oracle Certified Master

Beware default tablespace during Data Pump import

Posted by Kamran Agayev A. on December 19th, 2014

Today, while importing one database to another, my colleague (Turkel) got a tablespace issue despite the fact that he used REMAP_TABLESPACE for almost all available tablespaces of the source database. After investigating, we saw that there’re a lot of users that was assigned a default tablespace which was deleted afterwards. While importing data, the user was supposed to be created and deleted tablespace was assigned as a default tablespace

For this, make sure you get distinct account of default tablespaces of all users and change it during import using REMAP_TABLESPACE parameter

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>