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,...