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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: CLOB data

Re: CLOB data

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Thu, 16 Oct 2003 20:24:25 -0800
Message-ID: <F001.005D36CC.20031016202425@fatcity.com>


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

Original text of this message

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