DROP CONCURRENT_LIMITING_RULE

Purpose

This statement is used to drop a concurrent limiting rule.

Limitations and considerations

To execute the DROP CONCURRENT_LIMITING_RULE statement in Oracle mode of OceanBase Database, you must have the drop any concurrent_limiting_rule privilege.

Syntax

DROP CONCURRENT_LIMITING_RULE [ IF EXISTS ] "ccl_rule_name1" [, "ccl_rule_name2", ...]

Here, ccl_rule_name specifies the name of the concurrent limiting rule.

Examples

Execute the following statement to drop the sql1_keywords_ccl_rule and sql2_keywords_ccl_rule concurrent limiting rules.

obclient> DROP CONCURRENT_LIMITING_RULE "sql1_keywords_ccl_rule","sql2_keywords_ccl_rule";