3 Replies Latest reply: Feb 8, 2013 10:57 AM by Richard Harrison . RSS

    ORA-39000: bad dump file specification

    Mishra
      Hi ,

      i exported the dumpfile with %U and its genereated successfully with suffix of 101..102..till 243.

      But while importing its searching the file from 01 02 and so in other env.

      Could you please assist.

      Actual file name start with:
      Dump file set for EXPDPUSER.EXPFULL_NW is:
        +LMDRPRDERDWDB_ASM_DATA_DISK9/asm_dpump/prod_data_expdb_nw101.dmp
        +LMDRPRDERDWDB_ASM_DATA_DISK8/asm_dpump/prod_data_expdb_nw201.dmp
        +LMDRPRDERDWDB_ASM_DATA_DISK9/asm_dpump/prod_data_expdb_nw102.dmp
        +LMDRPRDERDWDB_ASM_DATA_DISK8/asm_dpump/prod_data_expdb_nw202.dmp
        +LMDRPRDERDWDB_ASM_DATA_DISK9/asm_dpump/prod_data_expdb_nw103.dmp
        +LMDRPRDERDWDB_ASM_DATA_DISK8/asm_dpump/prod_data_expdb_nw203.dmp
        +LMDRPRDERDWDB_ASM_DATA_DISK9/asm_dpump/prod_data_expdb_nw104.dmp
        +LMDRPRDERDWDB_ASM_DATA_DISK8/asm_dpump/prod_data_expdb_nw204.dmp
        +LMDRPRDERDWDB_ASM_DATA_DISK9/asm_dpump/prod_data_expdb_nw105.dmp
      ..........
      ..................
      
        +LMDRPRDERDWDB_ASM_DATA_DISK8/asm_dpump/prod_data_expdb_nw242.dmp
        +LMDRPRDERDWDB_ASM_DATA_DISK9/asm_dpump/prod_data_expdb_nw143.dmp
      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      With the Partitioning, Automatic Storage Management, OLAP, Data Mining
      and Real Application Testing options
      ORA-39001: invalid argument value
      ORA-39000: bad dump file specification
      ORA-31640: unable to open dump file "+LMDRSITERDB_ASM_DATA1/dpump/PROD_data_expdb_NW01.dmp" for read
      ORA-17503: ksfdopn:2 Failed to open file +LMDRSITERDB_ASM_DATA1/dpump/PROD_data_expdb_NW01.dmp
      ORA-15173: entry 'PROD_data_expdb_NW01.dmp' does not exist in directory 'dpump'
      Thanks,