how about using tablespaces UMDOTBS (instead of UNDOTBS) and SYTSEM?
thanks for the laugh.
Pd
Mladen Gogala <[EMAIL PROTECTED]> wrote:
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
