ORA-23419: regenerate replication support before resuming master activity

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');