Re: create index when add primary key

In <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

Yes. Use the using index clause of the table constraint syntax you may specify the tablespace of the Primary Key Index.

D. Scott Moyer, Jr.                        dmoyer_at_gpu.com (preferred for work)
GPU Service Corporation                dsmoyer_at_enter.net (preferred for home)