This discussion is archived
3 Replies Latest reply: Oct 19, 2013 12:07 PM by Srini Chavali-Oracle RSS

impdb dmp file error

user9126521 Newbie
Currently Being Moderated

Hi Guys,

 

A desperate call for help . i am trying to import a dmp file and i get the following error:

 

Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "C:\oracle\product\10.2.0\admin\orcl\dpd

 

The source database is 11.2.0.3 and was exported without using the version parameter and deleted. The target database is 10.2.0.1 and i understand the above error could be due to the version number mismatch.

 

Is there any any way to import this dmp? Any cheat any hack that you guys know. We dont have the source database and no oracle 11 db license or installer.

 

Thanks

 

Viv

  • 1. Re: impdb dmp file error
    sb92075 Guru
    Currently Being Moderated

    user9126521 wrote:

     

    Hi Guys,

     

    A desperate call for help . i am trying to import a dmp file and i get the following error:

     

    Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production

    ORA-39001: invalid argument value

    ORA-39000: bad dump file specification

    ORA-31619: invalid dump file "C:\oracle\product\10.2.0\admin\orcl\dpd

     

    The source database is 11.2.0.3 and was exported without using the version parameter and deleted. The target database is 10.2.0.1 and i understand the above error could be due to the version number mismatch.

     

    Is there any any way to import this dmp? Any cheat any hack that you guys know. We dont have the source database and no oracle 11 db license or installer.

     

    Thanks

     

    Viv

     

    >Is there any any way to import this dmp?

    must be imported at V11.2.0.3 or higher

  • 2. Re: impdb dmp file error
    Girish Sharma Guru
    Currently Being Moderated

    Check below thread :

    https://forums.oracle.com/message/10879692

     

    Regards

    Girish Sharma

  • 3. Re: impdb dmp file error
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    If the VERSION parameter was not used, then the dumpfile cannot be imported into a lower version database. Pl see MOS Doc 549750.1. Pl open an SR with support to confirm

     

    HTH
    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points