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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
