How to create 2 unique indexes (Field1, Field2) and (Field1, Fiel

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

How do I create 2 unique indexes (STDID,PAYGRP) and (ACCTNO,PAYGRP) on the
same table ?

I created the first index successfully but encountered the error "ORA-01452:
cannot CREATE UNIQUE INDEX; duplicate keys found" when I tried to create the
2nd index. 

SELECT INDEX_NAME,TABLE_NAME,UNIQUENESS FROM USER_INDEXES WHERE
TABLE_NAME='SPY_ADHOC_PAYMENT'

INDEX_NAME                     TABLE_NAME                     UNIQUENES
------------------------------ ------------------------------ ---------
U_SPYADH_1                     SPY_ADHOC_PAYMENT              UNIQUE

SQL> SELECT * FROM USER_IND_COLUMNS  WHERE TABLE_NAME='SPY_ADHOC_PAYMENT';

INDEX_NAME                     TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------
------------------------------
U_SPYADH_1                     SPY_ADHOC_PAYMENT              STDID
U_SPYADH_1                     SPY_ADHOC_PAYMENT              PAYGRP

SQL> CREATE UNIQUE INDEX U_SPYADH_2 ON SPY_ADHOC_PAYMENT (ACCTNO,PAYGRP);
CREATE UNIQUE INDEX U_SPYADH_2 ON SPY_ADHOC_PAYMENT (ACCTNO,PAYGRP)
                                  *
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Any advice ? Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).