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).
Received on Thu Oct 16 2003 - 23:24:25 CDT
