Re: CLOB

From: Yasenko Yorgich <elcaro_at_softhome.net>
Date: 13 Nov 2002 07:11:11 -0800
Message-ID: <ba8b6976.0211130711.4dac5380@posting.google.com>

Angela,

If I execute the same code, it works OK on windows 2000, oracle 8.1.7.3
SQL> l
  1 CREATE TABLE ALLOC_MFQUEUE

  2     (SEQ_NO NUMBER(15) NOT NULL
  3     ,PUB_STATUS VARCHAR2(1) NOT NULL
  4    ,MESSAGE_TYPE VARCHAR2(15) NOT NULL
  5     ,ALLOC_NO NUMBER(10) NOT NULL
  6     ,FROM_LOC_TYPE VARCHAR2(1) NOT NULL
  7     ,VIRTUAL_FROM_LOC NUMBER(10) NOT NULL
  8    ,PHYSICAL_FROM_LOC NUMBER(10) NOT NULL
  9     ,TO_LOC_TYPE VARCHAR2(1)
 10    ,TO_LOC NUMBER(10)

 11 ,ALLOC_STATUS VARCHAR2(1)
 12 ,ORIG_IND VARCHAR2(1)
 13 ,MESSAGE CLOB
 14 )
 15 STORAGE
 16 (

 17      INITIAL 100K
 18      NEXT 100K
 19     PCTINCREASE 0

 20 MAXEXTENTS 255
 21* ) TABLESPACE LOB_DATA
SQL> c/LOB_DATA/USERS
 21* ) TABLESPACE USERS
SQL> / Table created.

I'd beleive it would work on my linux machine, too, where I have RH Linux 8 with oracle 9.2 Received on Wed Nov 13 2002 - 09:11:11 CST