How to solve this error ?
Procedure is throwing an Ora-01555 error : snapshot too old error.
ORA-20001: An error was encountered - -20001 -ERROR- ORA-20001: An error was encountered - -1555 -ERROR- ORA-01555:
snapshot too old: rollback segment number 24554 with name "_SYSSMU24554_2608996880$" too small
ORA-02063: preceding line from ACT_PROD
ORA-02063: preceding 2 lines from NAR
ORA-06512: at "WFM_NF.SP_NF_PM_PROCESS_CONTROL", line 157
ORA-06512: at line 3
BELOW TABLE I USED
wfm_staging.NETASSIST_VW_TID_REPORT --- SYNONYMS
wfm_staging.NETASST_NG_TID_V tv,--TABLE
wfm_staging.NETASST_NG_TID_WF_TYPE_MAP_V tw,---TABLE
wfm_staging.NETASST_NG_STATUS_V ns,--TABLE
wfm_staging.NETASST_NG_EQUIP_WF_TYPE_MAP_V eq,--TABLE
WFM_NF.NF_IDS nf--TABLE
wfm_staging.NETASSIST_VW_TID_REPORT --- SYNONYMS--→THIS SYNONYM used by others
NOTE:
Procedure is throwing an Ora-01555 error : snapshot too old error.
The ACTP procedure is heavily reliant upon external sources.
I ran one procedure ,this procedure kills Procedure Control Batch every time: