Oracle 11G OCP 1Z0-052 102

（102）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 schema.dat@devdb.us.oracle.com.

D. Replace the schemas option with the network_link = devdb.us.oracle.com option.

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

答案：（E）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1189585/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1189585/