Re: Primary index storage

For tables which exist and primary keys which don't: alter table table_name
add constraint table_name_pk primary key (col1,col2)
using index tablespace tbspc_name
storage (initial xx next xx pctincrease xx) /

• the index will get the same name as the constraint -

HTH janet

Angelito Dizon wrote:
>
> Since Oracle automatically creates primary indexes, how can I specify
> storage parameters for a primary index?
>
> Thanks,
> Lito
>
> Lito Dizon
> adizon_at_us.net
Received on Mon Dec 16 1996 - 00:00:00 CST