What would be achieved by running the above commands?

Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.
S expdp system/manager
Schemas =hr,oe
directory =EXP_ DIR
include = table
$ impdp system/manager
Schemas = hr1,oe1
Directory = EXP_DIR
Dumpfile = export.dat
Remap_schema =hr:hr1,oe :oe1
What would be achieved by running the above commands?

Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.
S expdp system/manager
Schemas =hr,oe
directory =EXP_ DIR
include = table
$ impdp system/manager
Schemas = hr1,oe1
Directory = EXP_DIR
Dumpfile = export.dat
Remap_schema =hr:hr1,oe :oe1
What would be achieved by running the above commands?

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

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

C.
impdp will create two users called hrl and oe1 and import all objects to the new schemas

D.
impdp will create two users called hrl and oe1 and import tables owned by hr and oe schemas
to hr1 and oe1 schemas, respectively.



Leave a Reply 0

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