Re: primary key index on separate tablespace not possible?

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

You can name the index constraint at the same time you create the table command. You are not limited to either creating the indexes seperately or putting up with system generated constraint names. For example:

CREATE TABLE test (

   a NUMBER CONSTRAINT test_pk PRIMARY KEY,    b NUMBER);

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================