SAP Note 641435 - FAQ: Oracle Index Organized Tables (IOTs)

Composant : Oracle -

Solution : https://service.sap.com/sap/support/notes/641435 (Connexion à SAP Service Marketplace requise)

Mots Clés :
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>'

Notes associées :

1325304Conversions between heap-organized tables and IOTs
1135589IOT Corruptions a. Upgrade from COMPATIBLE <= 9.2 to >= 10.1
969396Convert table VDBEPI to Oracle Index Organized Table (IOT)
912620FAQ: Oracle indexes
832343FAQ: Clustering factor
176754Problems with CBO and RBO
105047Support for Oracle functions in the SAP environment