Re: INIT initial Extend For Primary Key Index ??

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 2 Aug 1999 17:58:49 GMT
Message-ID: <7o4m8p$a2j$6@news.seed.net.tw>

John Lescaut <developpement_at_cantoriel.fr> wrote in message news:7o3lgv$6vt$1_at_jaydee.iway.fr...
>
> I'd like to set the initial extend of a primary key index,
>
> For exemple :
>
> Create table Table1
> (
> test1 varchar2(12) NOT NULL,
> test2 varchar2(12) NOT NULL,
> test3 varchar2(15),
> test4 varchar2(15),
> DATE_test Date
> )
> STORAGE (INITIAL 48825 NEXT 6180 MINEXTENTS 1 MAXEXTENTS 10 PCTINCREASE 0 )
> ;
>
> Alter table Table1 Add constraint PK_Table1 primary key ( test1 ,
> test2 );
>
>
> I'd like to set the initial extend ok PK_Table1 at 60k for exemple,
> but the command :
> Alter Index PK_Table1 STORAGE (INITIAL 60k) isn't working, how can I manage
> to do something similar ??

Before Oracle 7.2, you can drop and recreate the index. On Oracle 7.2 or above, you can use the following statement to change an index's INITIAL parameter:

alter index pk_table1 rebuild storage (initial 60k); Received on Mon Aug 02 1999 - 12:58:49 CDT