Getting Unique Constraints while copying from 1 DB to other.

Quote:

Originally posted by SANJAY_G
Yes I was wrong, it can be before or after GROUP BY. Just checked, it is same on 7.3.4 as well.

Sanjay :

7i Sometimes gives erratic results ( this is wat i have heard from my colleagues...infact i never used 7i)

Now coming to the original problem....

Quote:

WW04:W_DBA> select
2 KURST,
3 FCURR,
4 TCURR,
5 GDATU
6 from wwciw_sap.ytcurr having count(*) > 1
7 group by
8 KURST,
9 FCURR,
10 TCURR,
11 GDATU;

no rows selected

Quote:

WW15:W_DBA> select kurst, fcurr, tcurr, gdatu, count(1) from ytcurr
2 group by kurst, fcurr, tcurr, gdatu
3 having count(1) > 1
4 /

KURS FCURR TCURR GDATU COUNT(1)
---- ----- ----- -------- ----------
M GRD USD 19990320 2
P USD PTE 19960901 2

Why Oracle is behaving stupidly here.....

Thanks
Abhay.