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

Home -> Community -> Usenet -> c.d.o.server -> Re: INIT initial Extend For Primary Key Index ??

Re: INIT initial Extend For Primary Key Index ??

From: Reinhard <reinhard_wahl_at_gmx.de>
Date: Mon, 02 Aug 1999 09:06:01 GMT
Message-ID: <37a55f2f.7110143@news.fhg.de>


On Mon, 2 Aug 1999 10:45:10 +0200, "John Lescaut" <developpement_at_cantoriel.fr> wrote:

Hi John
>
>I'd like to set the initial extend of a primary key index,

so you have to do it with USING INDEX-Syntax

Try for example:

Alter table Table1 Add constraint PK_Table1 primary key ( test1 , test2 ) USINF INDEX PCTFREE 20

                TABLESPACE user_x
                STORAGE (INITIAL 60K  NEXT 6K);

Bye
--
Reinhard



Please replace all '_' with '.' in e-mail adress to reply Received on Mon Aug 02 1999 - 04:06:01 CDT

Original text of this message

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