Re: primary key index on separate tablespace not possible?

ddf_dba_at_my-deja.com wrote:

> The USING INDEX clause is supported for the alter table command. This
> tells Oracle to utilize the index tablespace provided for the primary
> key index. You need not create the index first and connect it to the
> primary key constraint; the statement above will do all of that for you.

Hi

I personally prefer to create the index and the constraint separately, because I want the index and the constraint to have same name (for instance TABLE01_PK)

I don't like index names (like SYS_C00720 etc..) Oracle gives to indexes it creates implicitly for constraints.

regards. Kari

(Mr) Kari Pannila

     Oracle DBA (OCP)

PS. Delete X from my mail address , it (X) is only for SPAMMERS.

    Poista X mail-osoitteen edestä, se on SPAMmereita varten. Received on Wed Jun 07 2000 - 00:00:00 CDT