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?
A.
FULL
B.
SCHEMAS
C.
TRANSFORM
D.
REMAP_SCHEMA
E.
REMAP_TABLESPACE
Which option of IMPDP would you use to accomplish this task?
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?
Data Pump Import (invoked with the impdp command) is a new utility as of Oracle Database 10g. Although its functionality and its parameters are similar to those of the original Import utility (imp)
REMAP_SCHEMA – Loads all objects from the source schema into a target schema
REMAP_TABLESPACE – Remaps objects in the source tablespace and create in target tablespace.
In Oracle, users and schemas are essentially the same thing.