The conflict resolution fails and is noticed by the following entry in the event log:
Error 2009-07-03 00:45:32.315226 32100 4074503088 Table "OWNER_NAME"."TABLE_NAME" out of sync for queue <queue_name> at source rowid <rowID>
There is a table in the database that has the same name as one of the username in the database
Run the following query to see if it returns any row:
select table_name from dba_tables where table_name in (select username from dba_users);
If this turns out to be the case, then the table needs to be dropped or renamed before the conflict resolution can succeed. If the table is in replication, then renaming it would take it out of replication and it needs to be brought back into replication at a later time.
The solution applies to a particular scenario.
