Cause: There are tables in the object group that require regeneration of replication support. Action: Check the generation_status column in the all_repobjects view. Regenerate replication support for any table in the object group with a 'NEEDSGEN' status. Resume master activity. Example: EXEC DBMS_REPCAT.RESUME_MASTER_ACTIVITY ('SCOTT_REPG'); ORA-23419: regenerate
replication support before resuming master activity
Solution: 1. Check which object have the” NEEDSGEN” status
select sname,oname,gname,generation_status from all_repobject where generation_status='NEEDSGEN';
2. Regenerate Replication Support for the object where status is “NEEDSGEN” BEGIN 3. Resume Master Activity EXEC DBMS_REPCAT.RESUME_MASTER_ACTIVITY ('SCOTT_REPG'); |