OCP-1Z0-052-V8 02-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.

Answer: E  

答案解析：

[oracle@rtest ~]$ oerr ora 39000

39000, 00000, "bad dump file specification"

// *Cause:  The user specified a dump file that could not be used in the 

//          current job.  Subsequent error messages describe the inadequacies

//          of the dump file.

// *Action: Specify a dump file that is usable for the job.

[oracle@rtest ~]$ oerr ora 31640

31640, 00000, "unable to open dump file \"%s\" for read"

// *Cause:  Import was unable to open the export file for reading. This

//          message is usually followed by device messages from the operating

//          system.

// *Action: Take appropriate action to restore the device.

           

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow