7 Replies Latest reply: Jul 30, 2013 2:05 AM by DK2010 RSS

    datapump export very slow

    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 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))" but if I am using the or condition it is taking forever


       

      Can some please respond me as soon as possible

       

      Thank you

       

      Karren