SAP Knowledge Base Article - Preview

2867613 - Table reorg getting failed with ORA-20002

Symptom

"'BEGIN DBMS_STATS.EXPORT_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"<table>"', STATTAB => '"STATTAB"', STATID => '"20211026091749-73426"', CASCADE => TRUE, STATOWN => '"SYSTEM"'); END;'
ORA-20002: Version of statistics table "SYSTEM"."STATTAB" is too old.  Please try upgrading it with dbms_stats.upgrade_stat_table
ORA-06512: at "SYS.DBMS_STATS", line 20244
ORA-06512: at "SYS.DBMS_STATS", line 13254
ORA-06512: at "SYS.DBMS_STATS", line 4030
ORA-06512: at "SYS.DBMS_STATS", line 20202
ORA-06512: at line 1


Read more...

Environment

Upgrading Oracle database

Product

SAP ERP 6.0

Keywords

ORA-20002 , UPGRADE_STAT_TABLE , statistics , STATTAB ,DBMST_STATS , BRSPACE , DBMS_REDEFINITION; , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.