** table with clob slow

  • From: A Joshi <ajoshi977@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 22 Jun 2006 19:35:23 -0700 (PDT)

Hi,
     We have a big table and it has one field with CLOB datatype. Doing an 
export on this table is very slow. I have tried with different buffer sizes of 
2MB - 250MB. It is still slow. Any way to speed up export and other operations 
on the table like update,delete. Thanks for your help.

                
---------------------------------
Ring'em or ping'em. Make  PC-to-phone calls as low as 1¢/min with Yahoo! 
Messenger with Voice.

Other related posts: