SAP Knowledge Base Article - Preview

3037181 - ORA-01502 occurs in VALIDATE STRUCTURE job

Symptom

The following error occurs in VALIDATE STRUCTURE job:

BR0301E SQL error -1502 at location stats_tab_validate-2, SQL statement:
'ANALYZE TABLE "SYS"."WRH$_SYSMETRIC_HISTORY" VALIDATE STRUCTURE CASCADE ONLINE'
ORA-01502: index 'SYS.WRH$_SYSMETRIC_HISTORY_INDEX' or partition of such index is in unusable state
BR0893E Validating structure failed for table/cluster SYS.WRH$_SYSMETRIC_HISTORY


Read more...

Environment

SAP on Oracle

Product

SAP ERP 6.0

Keywords

WRH $ _SYSMETRIC_HISTORY_INDEX,WRH $ _SYSMETRIC_HISTORY,ORA-01502 , 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 ONE Support launchpad (Login required).

Search for additional results

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