DROP FAULT GROUP
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.
To add an orphaned node back to a fault group, you must manually reassign it to a new or existing fault group with CREATE FAULT GROUP and ALTER FAULT GROUP…ADD NODE.
For a list of all fault groups defined in the cluster, query system table FAULT_GROUPS .
Syntax
DROP FAULT GROUP [ IF EXISTS ] fault‑group
Parameters
IF EXISTS
|
Specifies not to report an error if fault‑group does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them. |
| fault‑group |
Specifies the name of the fault group to drop. |
Privileges
Superuser
Examples
=> DROP FAULT GROUP group2; DROP FAULT GROUP