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
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 79
ORA-06512: at “SYS.DBMS_REPCAT_MAS”, line 3528
ORA-06512: at “SYS.DBMS_REPCAT”, line 826
ORA-06512: at line 2
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
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (
sname => 'SCOTT',
oname => 'EMP',
type => 'TABLE');
END;
/
3. Resume Master Activity
EXEC DBMS_REPCAT.RESUME_MASTER_ACTIVITY ('SCOTT_REPG');