Nancy
From: Mladen Gogala <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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 <[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).
_________________________________________________________________
See when your friends are online with MSN Messenger 6.0. Download it now FREE! http://msnmessenger-download.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nancy Hu 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).