Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.
S expdp system/manager
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.