Oracle Support

Overview of an interesting bug

 Often you may need to load data to the database under a different schema and different tablespace. With Oracle Data Pump all this is possible in a very simple way. Among the various options of the routine impdp you can find:   REMAP_SCHEMA REMAP_TABLESPACE   REMAP_SCHEMA allows us to load the exported objects under a different scheme; REMAP_TABLESPACE allows us to load the exported objects under a different tablespace. Obviously, options can be used separately.   For example if we have the table ADMIN.TAB1 on tablespace ADMIN_TBS (which is not the default tablespace of schema ADMIN):   SQL> select owner, Read More