What would you do to overcome the error?

View the Exhibit to see the source and target databases.

You have created a database link, devdb.us.oracle.com, between the databases PRODDB and
DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from the
development database, DEVDB, to the production database, PRODDB. You execute the following
command on the target database server:
$impdp system/manager directory = DB_DATA
dumpfile = schemas.dat
schemas = hr
flashback_time = 2004-02-03 09:00
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?

View the Exhibit to see the source and target databases.

You have created a database link, devdb.us.oracle.com, between the databases PRODDB and
DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from the
development database, DEVDB, to the production database, PRODDB. You execute the following
command on the target database server:
$impdp system/manager directory = DB_DATA
dumpfile = schemas.dat
schemas = hr
flashback_time = 2004-02-03 09:00
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.
remove the dumpfile option in the command

B.
remove the flashback_time option in the command

C.
remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the
command

D.
add the user, SYSTEM, to the schemas option in the command

E.
remove the schemas option and add the network_link = devdb.us.oracle.com option in the
command

F.
add network_link = devdb.us.oracle.com option in the command



Leave a Reply 0

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