Index Organized Tables and PCTUSED...

From: Jay Harding <jhardin_at_vestek.com>
Date: 23 Jan 2002 12:05:43 -0800
Message-ID: <a8ee054f.0201231205.46794add@posting.google.com>

Probably a dumb question, but I was just wondering why you cannot specify PCTUSED in conjunction with an index ORGANIZED table.
For example, uncommenting the "PCTUSED 90" in the following DDL results in the error:

PCTUSED 90
*
ERROR at line 16:
ORA-25192: invalid option for an index-organized table

DDL FOLLOWS: DROP TABLE BLAH_IDXORG
;

CREATE TABLE BLAH_IDXORG
(

    COL_A          NUMBER NOT NULL,
    COL_B          NUMBER NOT NULL,
    COL_C          NUMBER NOT NULL,
    COL_D          NUMBER NOT NULL,
    COL_E          NUMBER     NULL,
    COL_F          NUMBER     NULL,

    CONSTRAINT PK_BLAH_IDXORG
    PRIMARY KEY (COL_A,COL_B,COL_C,COL_D) )
ORGANIZATION INDEX
TABLESPACE BLAH_IDX_01
LOGGING
PCTFREE 5
--PCTUSED 90
STORAGE (

       INITIAL 10M
       NEXT 10M ) 

;

quit
;

Thanks in anvance for any time you spend reading/thinking-about/answering this -- much appreciated!!

-jhardin_at_vestek.com Received on Wed Jan 23 2002 - 14:05:43 CST