Hi,
I would like to thank those who replied. Yes, my problem has been resolved
after removing duplicate values in the table. 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
Advice? Yes -- find out which records in your table have the duplicate
combination of ACCTNO,PAYGRP and either delete the duplicate row, correct
the problem row or don't create a unique index
From: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple
CHAN Chor Ling Catherine (CSC) wrote:
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
Hi,
The second index failed because of dups found. You will need to check the
data and correct them before creating the index.
The following should tell you which ones have dupl. values and how many
occured:
SELECT ACCTNO,PAYGRP,count(*) from SPY_ADHOC_PAYMENT group by ACCTNO,PAYGRP
having
Title: RE: How to create 2 unique indexes (Field1, Field2) and (Field1, Fiel
-Original Message-
From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]]
How do I create 2 unique indexes (STDID,PAYGRP) and
(ACCTNO,PAYGRP) on the
same table ?
I created the first index