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.