Register Login

SQL error 1555 occurred when accessing table

Updated May 18, 2018

I am getting below ORA-01555 in DB13 warnings in CHECKDB logs very often.
                     
Can you investigate the following problem: Abap YWDSR098 is scheduled daily. Since 01/08/2008 the progam is terminated with following error :
 SQL error 1555 occurred when accessing table "LTAK ".

 Database error text........: "ORA-01555: snapshot too old: rollback segment  
 number 12 with name "PRS_11" too small#"                                    
 Internal call code.........: "[RSQL/FTCH/LTAK ]"                             
 Please check the entries in the system log (Transaction SM21).               

This is temporarily coming and causing short dump ORA-01555 in ST22 because of report YWDSR098 or table LTAK.

Rollback tablespace is only 50% free. Table LTAK is computed by scheduling the job.

Kindly give any solution so that this temporary warning can be eliminated, pls keep in mind that the Rollback tablespace is 50% free and Table LTAK is being analysed manually by brconnect.


×