• 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.


  • 相关阅读:
    php分享三十:php版本选择
    php分享二十九:命名空间
    高性能mysql读书笔记(一):Schema与数据类型优化
    php分享二十八:mysql运行中的问题排查
    php分享二十七:批量插入mysql
    php分享二十六:读写日志
    Python | 一行命令生成动态二维码
    Python-获取法定节假日
    GoLang-字符串
    基础知识
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13316448.html
Copyright © 2020-2023  润新知