-
Title
Is it sufficient to remap Schema and tablespaces in order to decouple the new Schema completely f -
Description
In order to import with Data pump a complete Schema (Exported a whole schema and now want to import on another Schema- remapping schema, tablespaces and datafile. Is it sufficient to remap Schema and tablespaces in order to decouple the new Schema completely from the original.
-
Cause
This is an Oracle issue.
-
Resolution
Oracle Data Pump is an Oracle Utility and part of this utility is the remap Schema, Tablespace parameter.
Please refer the below link. If you want the destination schemas, tablespaces or datafiles to differ from the dumpfile, then you should remap them.
http://download.oracle.com/docs/cd/B14117_01/server.101/b10825/dp_import.htm#i1011943
Here is the information from the Oracle link above.
REMAP_SCHEMA
Default: none
Purpose:
Loads all objects from the source schema into a target schema.
Syntax and Description:
REMAP_SCHEMA=source_schema:target_schema
Multiple REMAP_SCHEMA lines can be specified, but the source schema must be different for each one. However, different source schemas can map to the same target schema. The mapping may not be 100 percent complete, because there are certain schema references that Import is not capable of finding. For example, Import will not find schema references embedded within the body of definitions of types, views, procedures, and packages.
This parameter requires the IMP_FULL_DATABASE role.
If the schema you are remapping to does not already exist, the import operation creates it, provided the dump file set contains the necessary CREATE USER metadata and you are importing with enough privileges. For example, the following Export commands would create the dump file sets with the necessary metadata to create a schema, because the user SYSTEM has the necessary privileges:
> expdp SYSTEM/password SCHEMAS=hr
> expdp SYSTEM/password FULL=y