Primary index storage

"Angelito Dizon" <adizon_at_mail.us.net> wrote:

>Since Oracle automatically creates primary indexes, how can I specify
>storage parameters for a primary index?

One way is to create the unique index first with the storage parameters you require. Then alter the table to create the primary key constraint. I believe the primary key constraint will use the existing index.

>
>Thanks,
>Lito
>
>Lito Dizon
>adizon_at_us.net
>

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP
25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555
Email gordonh_at_thehub.com.au
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ We are just two lost souls living in a fish bowl Year after year

Pink Floyd Received on Mon Dec 16 1996 - 00:00:00 CST