2 Replies Latest reply: Oct 29, 2013 2:20 AM by Anar Godjaev RSS

    Impdp related problem

    piku

      Hi All,

       

       

       

      I have one simple problem.I have impdp one dumpfile to one schemas.but on log file have found some of Indexes are not created due to temp tablespace problem.From the import log file I have got those 4 index name.

      Now I want to import only those indexes from dump file.Would it be possible.

      Plase share with me your valuable knowledge.

      Thanks in advance.

      piku.

        • 1. Re: Impdp related problem
          Padma....

          Hi

           

          impdp hr/hr dumpfile=hrdp.dmp directory=data_pump_dir include=index content=metadata_only


          thanks

          Padma....

          • 2. Re: Impdp related problem
            Anar Godjaev

            Hi,

             

            Just the query command set parameter include=indexes and try if u select specific index :

             

            impdp syste,/****** dumpfile=anar.dmp directory=Data_Pump_Dr include=index content=metadata_only

             

            OR

             

            impdp system/**** dumpfile=anar.dmp directory=Dta_Pmp_Dr  include=schames_name.a,b,c,d

             

            a - index_name

            b_index_name

            c - index_name

            d - index_name

             

            Thank you