Re: INIT initial Extend For Primary Key Index ??

In article <7o4m8p$a2j$6_at_news.seed.net.tw>, fumi_at_tpts5.seed.net.tw says...
>
> 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);
>
>
>
>

Or at creating the constraint
alter table table1 add constraint primkey (test1) using index storage (initial 60k next 60k pctincrease 0) tablespace xyz

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Aug 02 1999 - 14:00:33 CDT