Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ** table with clob slow

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US