Re: *** Index on a Primary Key ????

. wrote:
>
> Hello Everybody,
>
> I am trying to create an index on a primary key that's a part of combined
> primary keys (which are all indexed as multiple index ofcoarse). When I type
> the command
>
> CREATE INDEX xyz_idx on Table_Name (col_name);
>
> This gives me an error message saying that the index already exists, how can I
> execlude the column I'm trying to create the index on, from the multiple index
> set on it by the DBA as a part of a combined primary key ??
>
> I don't have the privilage (as a client) to drop and recreate an index on the
> multiple index that already exists (that was defined by the DBA) I only have
> the privilage to create a new index in the default table space.
>
> I would really appreciate your reply. Thanks.
>
> Elhamy

When you specified a col or cols to be pk of the table. Oracle already creates the index for you.

-- 
John Y. Chan
Manager, Data Services
RTE Asset Management (aka. Rightime Econometrics, Inc.)
1095 Rydal Rd.
Rydal, PA 19046
(215) 572-7288 (Voice)
(215) 572-6254 (Fax)