Oracle
1Z0-067 · Question #17
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…
The correct answer is B. expdp will succeed butimpdp will fail because the users do not exist. ORA-39165: Schema not found error will be resulted
Core Concepts and Tools
Question
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?
Options
- Aexpdp will fail because no path has been defined for the dump file.
- Bexpdp will succeed butimpdp will fail because the users do not exist.
- Cinpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
- Dimpdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe
How the community answered
(33 responses)- A6% (2)
- B76% (25)
- C3% (1)
- D15% (5)
Explanation
ORA-39165: Schema not found error will be resulted
Topics
#Data Pump#remap_schema#impdp#schema migration
Community Discussion
No community discussion yet for this question.