solidDB Help : solidDB reference : SQL: Statements : DROP CACHE SEGMENT
  
DROP CACHE SEGMENT
DROP CACHE SEGMENT cache‑segment‑name
Access requirements
SYS_ADMIN_ROLE role
Usage
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:
DROP CACHE SEGMENT HISTORY_CACHE
Go up to
SQL: Statements