1Z0-052 · Question #63
database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server: $ impdp s
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #63. The question stem and answer options stay visible for context.
Question
database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server:
$ impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')" The command fails displaying the following error:
ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037:
unable to obtain file status What would you do to overcome the error?
Options
- AAdd the user, SYSTEM, to the schemas option.
- BAdd the network_link = devdb.us.oracle.com option.
- CChange the dumpfile option to [email protected].
- DReplace the schemas option with the network_link = devdb.us.oracle.com
- EReplace the dumpfile option with the network_link = devdb.us.oracle.com
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.