Re: INIT initial Extend For Primary Key Index ??

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 02 Aug 1999 22:15:10 +0800
Message-ID: <37A5A7EE.4D92@yahoo.com>

Markus Korn wrote:
>
> try:
> create table ....
> ...
> ..
> constraint pk_table primary key
> using index pctfree 10
> tablespace index
> storage (initial 60k next20k ...)
> )
> STORAGE (INITIAL 48825 NEXT 6180 MINEXTENTS 1 MAXEXTENTS 10 PCTINCREASE
> 0 )
> ;
>
>
> John Lescaut wrote:
> >
> > 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 ??
> >
> > Thanks,
> >
> > John

I'd recommend PCTFREE 0 on indexes since a block won't get re-used until its totally empty anyway...

Cheers
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Aug 02 1999 - 09:15:10 CDT