What will happen when running these commands?

Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.

$expdp system/manager schemas = hr.oe directory = EXP_DIR

dumpfile = export.dat include = table
$ impdpsysten/manager schemas = hr1,
oe1 directory = EXP_DIR dumpfile = export.dat remap_schena=hr:hrl, oe:oe1

What will happen when running these commands?

Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.

$expdp system/manager schemas = hr.oe directory = EXP_DIR

dumpfile = export.dat include = table
$ impdpsysten/manager schemas = hr1,
oe1 directory = EXP_DIR dumpfile = export.dat remap_schena=hr:hrl, oe:oe1

What will happen when running these commands?

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

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

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

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



Leave a Reply 3

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