nerdexam
Oracle

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.

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

How the community answered

(40 responses)
  • B
    3% (1)
  • D
    93% (37)
  • E
    5% (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.

AFULL

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.

BSCHEMAS

SCHEMAS specifies which schemas to include in the import operation but does not remap them to a different schema name in the target database.

CTRANSFORM

TRANSFORM modifies the DDL generated during import (for example, removing storage attributes) and does not affect schema ownership or naming.

DREMAP_SCHEMACorrect

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.

EREMAP_TABLESPACE

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

#Data Pump import#REMAP_SCHEMA#schema migration#IMPDP

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice