Which objective would be achieved by the above command sets?

Examine the following commands of Data Pump to import objects to new non-existent users
hr1 and oe1.
$ expdp system/manager
schemas = hr,oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdp system/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schema = hr:hr1, oe:oe1
Which objective would be achieved by the above command sets?

Examine the following commands of Data Pump to import objects to new non-existent users
hr1 and oe1.
$ expdp system/manager
schemas = hr,oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdp system/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schema = hr:hr1, oe:oe1
Which objective would be achieved by the above command sets?

A.
expdp will fail because no path has been defined for the dumpfile.

B.
impdp would create two schemas called hr1 and oe1 and copy the schema objects to the
new users.

C.
impdp would create two schemas called hr1 and oe1 and import tables owned by hr and
oe schemas to hr1 and oe1 schemas, respectively.

D.
expdp will succeed but Impdp will fail because users do not exist.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *