Prev Question
Next Question

View the Exhibit to see the source and target databases.

You have created a database link,, 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?

remove the dumpfile option in the command

remove the flashback_time option in the command

remove the dumpfile option and add the network_link = option in the

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

remove the schemas option and add the network_link = option in the

add network_link = option in the command

Prev Question
Next Question

Leave a Reply

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