datremap_schema = hr:hr1, oe:oe1Which objective would be achieved by the above command set?

Examine the following commands of Data Pump to import objects to new non-existing 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 set?

Examine the following commands of Data Pump to import objects to new non-existing 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 set?

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

B.
Expdp will succeed but Impdp will fail because users do no exist.

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

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



Leave a Reply 2

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


Google

Google

We like to honor a lot of other internet sites on the net, even though they arent linked to us, by linking to them. Below are some webpages really worth checking out.