altering uniform extent size

[ksbrace]

Hello,
I'm getting the following error from the following create table clause. I am thinking that the column of datatype xmltype is implemented as a form of lob and so the fact that the uniform extent size (16k) <= 4 * the block size (8k) is what is causing this problem. Is it possible to change the uniform extent size???

SQL> CREATE TABLE GURCARD
  2  (
  3      GURCARD_ROLE            VARCHAR2(200)     NOT NULL,
  4      GURCARD_XML             XMLTYPE           NOT NULL,
  5      GURCARD_USER_ID         VARCHAR2(30)      NOT NULL,
  6      GURCARD_ACTIVITY_DATE   DATE              NOT NULL,
  7      GURCARD_DATA_ORIGIN     VARCHAR2(30)
  8    )
  9  STORAGE         (
 10                  INITIAL         &MSMLTAB_INITIAL_EXTENT
 11                  NEXT            &MSMLTAB_NEXT_EXTENT
 12                  MINEXTENTS      &MSMLTAB_MIN_EXTENTS
 13                  MAXEXTENTS      &MSMLTAB_MAX_EXTENTS
 14                  PCTINCREASE     &MSMLTAB_PCT_INCREASE
 15                  )
 16  TABLESPACE                      &MSMLTAB_TABLESPACE_NAME
 17  PCTFREE                         &MSMLTAB_PCT_FREE
 18  PCTUSED                         &MSMLTAB_PCT_USED
 19  ;
CREATE TABLE GURCARD
*
ERROR at line 1:
ORA-03237: Initial Extent of specified size cannot be allocated in tablespace (D
EVELOPMENT)

Metalink Note: 116310.1
Problem Description
-------------------

You try to create a table with a LOB column in a locally managed tablespace and
get the following error:

ORA-3237 "Initial Extent of specified size cannot be allocated"
// *Cause: Too large a size for an initial extent due to freelist
// group specification
// *Action: Reduce number of freelist groups specified for segment

Solution Description
--------------------

You need to ensure that the extent size specification in the tablespace is
at least four times the db_block_size.

i.e:
create tablespace local_t1
datafile 'path/filename.dbf' size 20M
extent management local uniform size N;
*** where N = 4*db_block_size ***

 

[LKBrwnDBA]

No, you need to drop/re-create the tablespace.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb