Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Index Organized Tables and PCTUSED...

Re: Index Organized Tables and PCTUSED...

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 23 Jan 2002 21:10:26 +0000
Message-ID: <3C4F26C2.4037@yahoo.com>


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

An IOT is stored as an index - you can't set pctused for an index thus you cannot for an IOT. The reason is that index blocks are only reused (elsewhere within an index) when they become totally empty - thus making the pctused concept moot.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Wed Jan 23 2002 - 15:10:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US