Oracle
1Z0-052 · Question #5
1Z0-052 Question #5: Real Exam Question with Answer & Explanation
The correct answer is D. REMAP_SCHEMA. IMPDP's REMAP_SCHEMA parameter redirects imported objects from a source schema to a differently named target schema during an Oracle Data Pump import.
Moving Data
Question
You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?
Options
- AFULL
- BSCHEMAS
- CTRANSFORM
- DREMAP_SCHEMA
- EREMAP_TABLESPACE
Explanation
IMPDP's REMAP_SCHEMA parameter redirects imported objects from a source schema to a differently named target schema during an Oracle Data Pump import.
Common mistakes.
- A. FULL=Y imports every object in the entire dump file without any schema filtering or renaming, which would not isolate or remap the APPS schema objects.
- B. SCHEMAS specifies which schemas to include in the import operation but does not remap them to a different schema name in the target database.
- C. TRANSFORM modifies the DDL generated during import (for example, removing storage attributes) and does not affect schema ownership or naming.
- E. REMAP_TABLESPACE reassigns objects from one tablespace to another during import, not from one schema owner to another.
Concept tested. Oracle Data Pump IMPDP REMAP_SCHEMA parameter
Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/datapump-import-utility.html
Topics
#Data Pump import#REMAP_SCHEMA#schema migration#IMPDP
Community Discussion
No community discussion yet for this question.