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.
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

Explanation:
The Data Pump import command, impdp, can now use this database link to directly access remote
data. The command line parameter NETWORK_LINK points to the source database via its
database link.
When you use the network_link parameter, you directly import from the remote database. There is
no export made, and directories are not used.



Leave a Reply 1

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


Aramaism Statius

Aramaism Statius

Question should read:
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.

The beginning was cut off. THANK YOU!