Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Index Organized Tables and PCTUSED...
For the same reason you can't in an index.
Daniel Morgan
Jay Harding wrote:
> 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 - 06:55:19 CST