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