Re: CLOB data

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Thu, 16 Oct 2003 15:59:25 -0800
Message-ID: <F001.005D36B0.20031016155925@fatcity.com>

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.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 Thu Oct 16 2003 - 18:59:25 CDT