Using Flash Cash on Tables with Exadata

When creating tables to use Exadata Flash Cash use the sintaxe below:

CREATE TABLE tab1 (col1 number)
PARTITION BY RANGE (col1)
(PARTITION p1 VALUES LESS THAN (1000)
STORAGE (CELL_FLASH_CACHE KEEP),
PARTITION p2 VALUES LESS THAN (2000)
STORAGE (CELL_FLASH_CACHE NONE),
PARTITION p3 VALUES LESS THAN (3000)
STORAGE (CELL_FLASH_CACHE DEFAULT));


You can also use ALTER TABLE or ALTER INDEX as follows:

ALTER INDEX idx1 STORAGE (CELL_FLASH_CACHE KEEP);


Best Regards,
Paulo Portugal