SAP Knowledge Base Article - Preview

1558849 - ORA-1502 or ORA-900: index or partition of index is in unusable state during BW dataload

Symptom

Brconnect - Checkdb  or DB02, reports any of the following errors

  • ORA-1502: index or partition of index is in unusable state
  • 900 index in usuable state with SAP Basis 7.00/7.01/7.02
  • ORA-20000: index "owner"."index_name~900"  or partition of such index
    is in unusable state
  • BR0970W Database administration alert - level: ERROR, type:
    "MISSING_INDEX, object: (index) "owner"."index_name~900" (unusable)"

 


Read more...

Environment

  • SAP Release Independent
  • SAP Netweaver -  BW

Product

SAP enhancement package 1 for SAP NetWeaver 7.0

Keywords

ORA-1502, Index, Unusable State, Datastaging, Data Load, PSA, infocube, MISSING_INDEX, object: (unusable), ORA-20000 (unusable) , KBA , BW-SYS-DB-ORA , BW 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.