CLOB

From: Angela Adams <AADAMS7_at_carolina.rr.com>
Date: Tue, 12 Nov 2002 18:15:24 GMT
Message-ID: <0zbA9.96101$dn3.3885936@twister.southeast.rr.com>

I am having a problem creating a table with the datatype of CLOB in a specific tablespace that is using locally managed extents. I get the following error:

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - 64bit Production With the Partitioning option
JServer Release 9.0.1.0.0 - Production

SQL> 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;
CREATE TABLE ALLOC_MFQUEUE
*
ERROR at line 1:
ORA-03001: unimplemented feature

I can create this same table in the SYSTEM tablespace without any problem?? Any ideas?

Thank you in advance. Received on Tue Nov 12 2002 - 12:15:24 CST