Oracle7 Server Administrator's Guide

Contents Index Home Previous Next

Altering Hash Clusters

You can alter a hash cluster with the SQL command ALTER CLUSTER:

ALTER CLUSTER emp_dept . . . ;

The implications for altering a hash cluster are identical to those for altering an index cluster. However, note that the SIZE, HASHKEYS, and HASH IS parameters cannot be specified in an ALTER CLUSTER statement. You must re-create the cluster to change these parameters and then copy the data from the original cluster.

See Also: For more information about altering an index cluster, see "Altering Clusters" [*].


Contents Index Home Previous Next