How to disable flash cache in storage clause for a partitioned index?
Following a recommendation given by an Oracle analyst, we disabled the flash cache in storage clause for all indexes in our ODA X5-2.
eg.:
alter index mercury.idx_mercury_01 storage (flash_cache none);
However, for partitioned indexes this modification is not being made. We still have 11 indexes in that situation:
select index_name, flash_cache, partitioned from dba_indexes where flash_cache <> 'NONE' and owner in (select username from dba_users where oracle_maintained = 'N') and index_type <> 'LOB' and temporary = 'N' and index_type not like '%IOT%';
INDEX_NAME FLASH_CACHE PARTITIONED
-------------------------------------------------- --------------- --------------------
IDX_CU_DATETIME DEFAULT YES