Kamran Agayev's Oracle Blog

Oracle Certified Master

Archive for the 'Oracle Utilities' Category

Beware default tablespace during Data Pump import

Posted by Kamran Agayev A. on 19th December 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

Posted in Oracle Utilities | No Comments »

Welcome to my Oracle Blog

Posted by Kamran Agayev A. on 24th November 2008

Hi All. Welcome to my Oracle Blog. In this blog, I’ll try to add new solutions for some problems and provide briefly examples. Moreover, I’m planning periodically to analyze some administration features of Oracle database

Posted in Administration, DBA scripts, Interview questions, Oracle on Linux, Oracle Utilities, Qafqaz University, SQL and PL/SQL | 15 Comments »