|
|
ALTER CLUSTER
Change the storage properties of a cluster.
Syntax:
ALTER CLUSTER schema.cluster options
options:
The options used with this command can be any
combination of the following
PCTUSED int PCTFREE int INITRANS int MAXTRANS int SIZE int K | M TABLESPACE tablespace_name STORAGE storage_clause ALLOCATE EXTENT ALLOCATE EXTENT SIZE int K | M ALLOCATE EXTENT DATAFILE 'filename' ALLOCATE EXTENT INSTANCE int DEALLOCATE UNUSED DEALLOCATE UNUSED KEEP int K | M INSTANCE instance_no PARALLEL parallel_clause
If the PARALLEL clause is used it should be the last option.
Related Commands:
ANALYZE CLUSTER COMPUTE STATISTICS
CREATE CLUSTER
Related Views:
DBA_CLUSTERS ALL_CLUSTERS USER_CLUSTERS DBA_DATA_FILES