The DROP CACHE SEGMENT statement removes cache segments from the database. You can only drop segments that do not have tables or rows assigned to it. If the segment name does not exist or the segment has tables/rows assigned to it, the operation fails with error 13471. Before dropping a cache segment, all table assignations to the segment must be dropped.
Parameters
name
Identifies the 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: