1Z0-052 · Question #5
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?
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.
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
How the community answered
(40 responses)- B3% (1)
- D93% (37)
- E5% (2)
Why each option
IMPDP's REMAP_SCHEMA parameter redirects imported objects from a source schema to a differently named target schema during an Oracle Data Pump import.
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.
SCHEMAS specifies which schemas to include in the import operation but does not remap them to a different schema name in the target database.
TRANSFORM modifies the DDL generated during import (for example, removing storage attributes) and does not affect schema ownership or naming.
REMAP_SCHEMA=APPS:DB_USR tells Data Pump to take all objects owned by the APPS schema in the export dump file and create them under the DB_USR schema in the target database. This is the precise mechanism for cross-schema imports where the source and destination schema names differ across environments.
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
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/datapump-import-utility.html
Topics
Community Discussion
No community discussion yet for this question.