多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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 betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server:$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = 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 valueORA-39000: bad dump file specification ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable toobtain 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
  • E、Replace the dumpfile option with the network_link = devdb.us.oracle.com
正确答案:E
答案解析:
进入题库查看解析

微信扫一扫手机做题