Getting Unique Constraints while copying from 1 DB to other.

[abhaysk]

I am trying to copy data from PRO to ACP for some testing purpose....
but am getting unique constraint even though there dosent exist any dupilcate records in PRO...
Because both ACP & PRO have PK set of columns same...i belive i should not get this error....i mean it dosent make sense...

PS below

ACP side

WW15:W_DBA>copy from wwciw_dba@ww04 to wwciw_dba@ww15 insert WWCIW_SAP.ytcurr using select * from wwciw_sap.ytcurr
FROM*********
TO*****

Array fetch/bind size is 1. (arraysize is 1)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)

ERROR:
ORA-00001: unique constraint (WWCIW_SAP.SYS_C001519) violated


WW15:W_DBA>select * from dba_cons_columns where constraint_name='SYS_C001519';

OWNER                          CONSTRAINT_NAME                TABLE_NAME                     COLUMN_NAME        
------------------------------ ------------------------------ ------------------------------ -------
WWCIW_SAP                      SYS_C001519                    YTCURR                         KURST              
WWCIW_SAP                      SYS_C001519                    YTCURR                         FCURR              
WWCIW_SAP                      SYS_C001519                    YTCURR                         TCURR              
WWCIW_SAP                      SYS_C001519                    YTCURR                         GDATU

PRO Side

WW04:W_DBA>select * from dba_cons_columns where constraint_name='SYS_C001519';

OWNER                          CONSTRAINT_NAME                TABLE_NAME                     COLUMN_NAME        
------------------------------ ------------------------------ ------------------------------ ------------
WWCIW_SAP                      SYS_C001519                    YTCURR                         KURST              
WWCIW_SAP                      SYS_C001519                    YTCURR                         FCURR              
WWCIW_SAP                      SYS_C001519                    YTCURR                         TCURR              
WWCIW_SAP                      SYS_C001519                    YTCURR                         GDATU              

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

Can any body throw some light??

am confused...

Thanks
Abhay.