Solution : https://service.sap.com/sap/support/notes/1325304 (SAP Service marketplace login required)
Summary :
The SAP Note discusses improvements in the process of converting heap tables to Index-Organized Tables (IOTs) and vice versa using BRSPACE. Initially, converting a heap table to IOT required manual efforts, but this has been automated. The process uses the package DBMS_REDEFINITIONS and the heap2iot action in BRSPACE for conversion, requiring a specified unique index. Conversely, iot2heap action converts IOTs back to heap tables. These operations facilitate online management without needing offline ALTER TABLE MOVE. Users must be aware of potential ORA-01429 errors indicating unsuitability for IOT conversion due to record size.
Key words :
brspace online reorganization required manual intervention, automated - manual intervention, brspace online reorganization, terms br tools, - sap primary index, oracle error ora-01429, index-organized tables, alter table move, exists <ind_id> - index, index-organized table
Related Notes :
| 1060305 | Corrections in BR*Tools Version 7.10 |
| 641435 | FAQ: Oracle Index Organized Tables (IOTs) |