REMAPSCHEMA - Definition,Properties - Oracle Datafiles and Tempfiles

Q.  You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?
- Published on 12 Aug 15

a. FULL
b. SCHEMAS
c. REMAP_SCHEMA
d. REMAP_DATAFILES
e. REMAP_TABLESPACE

ANSWER: REMAP_SCHEMA
 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - REMAP_DATAFILE - Changes the name of the source datafile to the target datafile name in all SQL statements where the source datafile is referenced: CREATE TABLESPACE, CREATE LIBRARY, and CREATE DIRECTORY.
    - Syntax
    REMAP_DATAFILE=source_datafile:target_datafile

    - REMAP_SCHEMA - Loads all objects from the source schema into a target schema.
    - Syntax
    REMAP_SCHEMA=source_schema:target_schema

    - REMAP_TABLESPACE - Remaps all objects selected for import with persistent data in the source tablespace to be created in the target tablespace.
    - Syntax
    REMAP_TABLESPACE=source_tablespace:target_tablespace

    - SCHEMAS - Specifies that a schema-mode import is to be performed.
    - Syntax
    SCHEMAS=schema_name [,...]

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)