Advanced replication and foreign key constraint

Hi,
I needed to alter a table that was in replication and while adding the table back into replication (dbms_repcat.create_master_repobject) after making the changes, I got a ORA-02992 and a ORA-02266. The table that I was looking to add and the other table that has the constraint are both exactly the same in both replication sites. I have copy_rows parameter set to true.

I was able to add the table back into the replication group by 1) disabling the constraint or 2) by changing copy_rows to false. I am not sure what the problem is. Does copy_rows=true attempt to copy all rows and just ignore the duplicate records?

Thanks
Pradeep Received on Sat Feb 24 2007 - 22:30:36 CST