Tables are not replicating data (4282394)

After activation the tested DML on demo table is not replicated.

The issue is that sys.obj$ has two object ids 70177 and 18 and one of the them is bogus 70177. If capture picks this 70177 as the max system object id, then any object# lower than 70177 won't get replicated.

SQL> select OWNER#, OBJ# from sys.obj$ where name ='OBJ$';

OWNER# OBJ#
---------- ----------
0 70177
0 18

SQL> select OBJECT_NAME, OBJECT_ID, OWNER from dba_objects where OBJECT_ID=70177;

no rows selected

Remove the bogus object id from the sys.obj$ table for 'OBJ$'.

The query to get the system object id that Capture monitors is:

select obj# from sys.obj$ where owner#=0 and name=XXXXXX
XXXXXX is the system object's name (e.g. OBJ$, COL$, etc).

See solution 47618 for more information on this.