SAP Knowledge Base Article - Preview

2767143 - BRSPACE Index decompression failing - ORA-14185

Symptom

During performing index decompression on partitioned table with BRSPACE, the rebuild is failing with error like:

///////////////////////
BR0280I BRSPACE time stamp
BR1151I Starting 'online' index rebuilding...
BR0280I BRSPACE time stamp
BR1155I Starting 'online' rebuilding of index <owner>.<index_name> ...
BR0280I BRSPACE time stamp
BR0301E SQL error -14185 at location ind_one_rebuild-10, SQL statement:
'ALTER INDEX "<owner>"."<index_name>" REBUILD PARTITION "<partition_name>" ONLINE NOCOMPRESS'
ORA-14185: incorrect physical attribute specified for this index partition
BR0280I BRSPACE time stamp
BR1157E Rebuild of index <owner>.<index_name> failed
BR0280I BRSPACE time stamp
BR1152I Number of indexes rebuilt successfully: 0
BR1153E Rebuild failed for 1 index(es)
///////////////////////


Read more...

Environment

Oracle database

Keywords

rebuild, index, compression, decompression, idrebuild, deactivate, compression, ORA-14185
 , KBA , BC-DB-ORA-DBA , Database Administration , 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.