nerdexam
Oracle

1Z0-497 · Question #12

YOU want to move all objects of the CONSULTANT user from the test database to the DB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?

The correct answer is D. REMAP_SCHEMA. FULL - Import everything from source [Y]. SCHEMAS - List of schemas to import. TRANSFORM - Metadata transform to apply to applicable objects. REMAP_SCHEMA - Objects from one schema are loaded into another schema. REMAP_TABLESPACE - Tablespace object are remapped to another…

Storage Configuration

Question

YOU want to move all objects of the CONSULTANT user from the test database to the DB-USER 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

(13 responses)
  • C
    8% (1)
  • D
    85% (11)
  • E
    8% (1)

Explanation

FULL - Import everything from source [Y]. SCHEMAS - List of schemas to import. TRANSFORM - Metadata transform to apply to applicable objects. REMAP_SCHEMA - Objects from one schema are loaded into another schema. REMAP_TABLESPACE - Tablespace object are remapped to another tablespace.

Topics

#Data Pump#IMPDP#REMAP_SCHEMA#schema migration

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice