Help Center> Data Warehouse Service> SQL Syntax Reference> DDL Syntax> CREATE BARRIER
View PDF

CREATE BARRIER

Function

Creates a barrier for cluster nodes. The barrier can be used for data restoration.

Precautions

Before creating a barrier, ensure that gtm_backup_barrier and enable_cbm_tracking are set to on for CNs and DNs in the cluster.

Syntax

1
 
CREATE BARRIER [ barrier_name  ] ;

Parameter Description

barrier_name

(Optional) Indicates the name of a barrier.

Value range: a string. It must comply with the naming convention.

Examples

1
2
3
4
5
 
-- Create a barrier without specifying its name:
CREATE BARRIER;

-- Specify a barrier name:
CREATE BARRIER 'barrier1';
Parent topic: DDL Syntax