What would you do to overcome the error?

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?

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?

A.
Change thedumpfile option to [email protected].

B.
Replace the schemas option with thenetwork_link = devdb.us.oracle.com

C.
Add thenetwork_link = devdb.us.oracle.com option.

D.
Add the user, SYSTEM, to the schemas option.

E.
Replace thedumpfile option with the network_link = devdb.us.oracle.com

Show Hint

Leave a Reply 2

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

jaehyun sung

jaehyun sung

Replace the dumpfile option with the network_link = devdb.us.oracle.com

Reply

Mous

Mous

here is the complete Question:

“You want to import schema objects of the HR user using Oracle Data Pump from the
development 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?
A. Add the user, SYSTEM, to the schemas option.
B. Add the network_link = devdb.us.oracle.com option.
C. Change the dumpfile option to [email protected].
D. Replace the schemas option with the network_link = devdb.us.oracle.com
E. Replace the dumpfile option with the network_link = devdb.us.oracle.com

Reply