Re: create index when add primary key

Bob,

THe syntax is:

              Create table tab1 ( col1 datatype ,... ,
       constraint <c1>  primary key (col1),
         using index
         tablespace <ts_name>
         storage ( ...)

Hope this helps.

--
Vikram Goel                                
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:                              Motorola email: vgoel_at_pts.mot.com
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 

In article <31D02EC4.19A6_at_itsi.disa.mil>, Bob Yeh <yehr_at_itsi.disa.mil> writes:


>Hi,

>

>Oracle create a unique index when the primary key is created.


>Is there a way to tell Oracle to create this index in certain

>tablespace when creating primary key?

>

>Thanks. Bob