| 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: CLOB data
Thanks Mladen for your wonderful explanation.
Nancy
>From: Mladen Gogala <mgogala_at_adelphia.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: CLOB data
>Date: Thu, 16 Oct 2003 20:24:25 -0800
>
>But the main point is valid. The phenomenon observed by Nancy is caused by
>the
>storage in the row.
>
>
>On 2003.10.16 19:59, Paul Drake wrote:
>>how about using tablespaces UMDOTBS (instead of UNDOTBS) and SYTSEM?
>>
>>thanks for the laugh.
>>
>>Pd
>>
>>Mladen Gogala <mladen_at_wangtrading.com> wrote:
>>This is because "ENABLE STORAGE IN ROW" is the default, which means
>>that oracle will store the first 4000 bytes in the original block.
>>The first part of a LOB is, essentially, identical to VARCHAR2(4000)
>>or VARRAW(4000). If you say something like
>>
>>CREATE TABLE t
>>(
>>ISCT_ID NUMBER(10),
>>CONTENT CLOB
>>)
>>TABLESPACE UNDOTBS
>>LOB(CONTENT) STORE AS LOB_CONTENTS (
>>TABLESPACE SYSTEM
>>DISABLE STORAGE IN ROW
>>NOCACHE
>>LOGGING)
>>/
>>
>>You will not be able to do that any longer. You cannot, however, exceed
>>4000 characters (I'm not sure what happens if the characters are
>>multibyte ones - may be Steve or Cary could help with that).
>>
>>
>>
>>---------------------------------
>>Do you Yahoo!?
>>The New Yahoo! Shopping - with improved product search
>
>--
>Mladen Gogala
>Oracle DBA
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nancy Hu INET: nancyhu68_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Oct 17 2003 - 13:42:25 CDT
 |
 |