6 Replies Latest reply: Jul 17, 2013 1:44 PM by SureshKumar.G RSS

    IMPDP - how to import one particular dump file data from the Clustered dumpfiles.

    SureshKumar.G


      Hi,

       

      Can anybody suggest me how shall I import the data from dumpfile using IMPDP, if the EXPDP has used many clustered Dumpfiles.?

      I want to import one particular file only, will that be possible?

       

      When I tried this way I was getting error.

       

      IMPDP USER/PWD@SID DIRECTORY=DATA_PUMP_DIR DUMPFILE=DUMPFILE01.DMP LOGFILE=IMPDP_DUMPFILE01.LOG SCHEMA=<NAME>

       

      ORA: 39002 INVALID OPERATION

      ORA: 39059 dump file set is incomplete

      ORA: 39246 can not locate master table within provided dumpfile.

       

      Note: The Exp was done in oracle 10g ( 10.2.0.4.0) , I am importing the dump file in Oracle 11.2.0.1.0

       

      Please advise on this.

       

      Regards

      Suresh