Oracle Error Message
ORA-25125: BUFFER_POOL/FLASH_CACHE/CELL_FLASH_CACHE storage option not allowed
Reason for the Error
An attempt was made to specify the BUFFER_POOL, FLASH_CACHE, or CELL_FLASH_CACHE storage option. This option may only be specified during
– CREATE or ALTER TABLE
– CREATE or ALTER CLUSTER
– CREATE or ALTER INDEX
Solution
Remove this option and retry the statement.