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 




Back to the Top

Simon Sheppard
SS64.com