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 for Me (Login required).

Search for additional results

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