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

SNAME

ONAME

GNAME

GENERATION_STATUS

SCOTT

EMP

SCOTT_REPG

 

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

Comments