Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR- ORA-01555: snapshot too old: rollback segment number 24554 with name "_SYSSMU24554_2608996880$" too small

suresh rajMay 23 2023

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:

Comments
Post Details
Added on May 23 2023
12 comments
405 views