Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.S expdp system/manager -Schemas =hr

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899566
Joined: Mon Aug 02, 2021 8:13 am

Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.S expdp system/manager -Schemas =hr

Post by answerhappygod »

Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.S expdp system/manager -Schemas =hr,oe -directory =EXP_ DIRinclude = table$ impdp system/managerSchemas = 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply