top of page
CerebroSQL

Oracle:

ALTER CLUSTER

ALTER CLUSTER [ schema. ]cluster
{ physical_attributes_clause
| SIZE size_clause
| allocate_extent_clause
| deallocate_unused_clause
| { CACHE | NOCACHE }
} ...
[ parallel_clause ] ;

example

ALTER CLUSTER personnel
SIZE 1024 CACHE;

ALTER CLUSTER language
DEALLOCATE UNUSED KEEP 30 K;

bottom of page