3 Replies Latest reply: Jul 29, 2013 5:46 PM by 991805 RSS

    datapump help

    991805

      Hi Gurus

       

      I am using the below par file and it is taking a long time. Can some one help me

       

      REUSE_DUMPFILES=Y

      dumpfile=S_b_07292013.dmp

      logfile=S_b_07292013.log

      DIRECTORY=DUMP51

       

       

      TABLES=PS_,PS_FO

       

      QUERY=PS_FO:"where ((c in (select c from bh_cr))

      or (co in (select co from bh_cons))

      or (or in (select or from bh_rs))

      or (fo in (select fo from bh_ans))

      or (em in (select em from bh_emp)))",PS:"where ((cust in (select cust from bh_cuer))

      or (cont in (select cont from bhts))

      or (oid in (select oid from bers))

      or (foid in (select foid from bhns))

      or (em in (select em from bhee)))"

       

      user/password@database export=exp.par

       

      and it has been running for ever can someone help me please

        • 1. Re: datapump help
          sb92075

          >Can some one help me

          what help do you expect or desire from here?

          • 2. Re: datapump help
            991805

            Can you please let me know the reason behind it going very slow. It has been stuck here for more than an hour

             

            Estimate in progress using BLOCKS method...

            Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

            Total estimation using BLOCKS method: 2.007 GB

            Processing object type TABLE_EXPORT/TABLE/TABLE

            Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

            Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

            Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

            Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

             

            if I use only the below condition it goes to success in matter of seconds

            QUERY=PS_FO:"where ((c in (select c from bh_cr))" if I am using the or condtion it is taking forever



            • 3. Re: datapump help
              Srini Chavali-Oracle

              Pl do not post duplicates - datapump export very slow