| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** table with clob slow
('binary' encoding is not supported, stored as-is)
Joshi
export / import of tables with LOB columns are exported one row at a time. Refer document *281461.1* for more details.**
Lines from the above document:
FIX
--- Although the performance of the export cannot be improved directly, possible alternative solutions are: 1. If not required, do not use LOB columns. <== Don't you love these workarounds ? or: 2. Use Transport Tablespace export instead of full/user/table level export. or: 3. Upgrade to Oracle10g and use Export DataPump and Import DataPump. ** Powell, Mark D wrote:Received on Fri Jun 23 2006 - 09:16:52 CDT
> Slow is a relative term. On average how big are the CLOB's? How many
> total bytes are you exporting? What is the average IO capacity of
> your target disk? Do a little math and determine if the elapsed time
> is really slow or just what it takes.
>
> HTH -- Mark D Powell --
>
>
> ------------------------------------------------------------------------
> *From:* oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *A Joshi
> *Sent:* Thursday, June 22, 2006 10:35 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* ** table with clob slow
>
> 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
> <http://us.rd.yahoo.com/mail_us/taglines/postman11/*http://us.rd.yahoo.com/evt=39666/*http://voice.yahoo.com>
> with Yahoo! Messenger with Voice.
>
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. -- http://www.freelists.org/webpage/oracle-l
 |
 |