** table with clob slow

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Thu, 22 Jun 2006 19:35:23 -0700 (PDT)
Message-ID: <20060623023523.82874.qmail@web60717.mail.yahoo.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 22 2006 - 21:35:23 CDT