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


  • 相关阅读:
    Windows Phone 开发 MD5计算
    php 3des加密算法以及与java,.net,c#的交互的一致性
    <加密算法c#>——— 3DES加密之ECB模式 和 CBC模式
    Blend PathListBox 使用
    计算机的几种类型单词、快捷键
    【SQL Server】 数据定义语言(定义基本表、完整性约束实现、索引)
    【SQL Server】 数据查询语句
    【WindowsPhone】 独立存储
    终结,铭记
    Day 3,4,5
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13316448.html
Copyright © 2020-2023  润新知