Solution : https://service.sap.com/sap/support/notes/641435 (SAP Service marketplace login required)
Key words :
alter index <index_name> update block references, primary key constraint requires unique combinations, transaction se14-> tools-> force conversion, alter table <table_name> move online, transaction se14-> storage parameters->, support important resb accesses, parallel data manipulation language, unavoidably produce undo data, dba_indexeswhere index_type = 'iot - top', pct_direct_accessfrom dba_indexeswhere table_name = '<table_name>'
Related Notes :
| 1325304 | Conversions between heap-organized tables and IOTs |
| 1135589 | IOT Corruptions a. Upgrade from COMPATIBLE <= 9.2 to >= 10.1 |
| 969396 | Convert table VDBEPI to Oracle Index Organized Table (IOT) |
| 912620 | FAQ: Oracle indexes |
| 832343 | FAQ: Clustering factor |
| 176754 | Problems with CBO and RBO |
| 105047 | Support for Oracle functions in the SAP environment |