DROP FAULT GROUP

A drop operation removes the specified fault group and its child fault groups, placing all nodes under the parent of the dropped fault group.

To drop all fault groups, use ALTER DATABASE..DROP ALL FAULT GROUP syntax.

To add an orphaned node back to a fault group, you must manually re-assign it to a new or existing fault group using a combination of CREATE FAULT GROUP and ALTER FAULT GROUP..ADD NODE statements.

Tip: For a list of all fault groups defined in the cluster, query the V_CATALOG.FAULT_GROUPS system table.

Syntax

DROP FAULT GROUP name

Parameters

name

Specifies the name of the fault group to drop.

Privileges

Must be a superuser to drop a fault group.

Example

The following example drops the group2 fault group from the cluster:

exampledb=> DROP FAULT GROUP group2;
DROP FAULT GROUP

See Also