Use the DROP CACHE SEGMENT statement to remove cache segments from the database.
You can drop only segments that do not have tables or rows assigned to them. Before dropping a cache segment, you must remove any table or row assignations to the segment, see ALTER TABLE ... ADD or DROP CACHE SEGMENT.
Return values
Error code
Description
13471
Table table_name does not have conditions for cache segment cache_segment_name.
Example
To drop the cache segment called HISTORY_CACHE:
1 Drop all table or row associations for the segment.
2 Use the following statement to remove the segment: