SQL Maestro Group / Products / Oracle / Oracle Maestro / Documentation

Oracle Maestro online help

A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common. Oracle Database stores together all the rows from all the tables that share the same cluster key.

New clusters are created within Create cluster Wizard. In order to run the wizard you should either

•	select the Object \| Create Database Object... main menu item;

•	select the Cluster icon in the Create Database Object dialog

•	select the Cluster list or any object from that list in the explorer tree;

•	select the Create New Cluster... item from the popup menu

•	open the schema in Schema Editor and the Cluster tab there;

•	press the Insert key or select the Create New Cluster item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

To create a new cluster with the same properties as one of the existing cluster has:

•	select the Object \| Duplicate Database Object... main menu item;

•	follow the instructions of Duplicate Object Wizard.

Clusters can be edited within Cluster Editor. In order to run the editor you should either

•	select the cluster for editing in the explorer tree (type the first letters of the

cluster name for quick search);

•	select the Edit Cluster... item from the popup menu

•	open the schema in Schema Editor and the Cluster tab there;

•	select the cluster to edit;

•	press the Enter key or select the Edit Cluster item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

To drop a cluster:

•	select the Cluster to drop in the explorer tree;

•	select the Drop Cluster item from the popup menu

•	open the schema in Schema Editor and the Cluster tab there;

•	select the cluster to drop;

•	press the Delete key or select the Drop Cluster item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

and confirm dropping in the dialog window.