SA_COMPONENTS.DROP_LEVEL is used to drop a level.
If a level is used in an existing tag, it cannot be dropped.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL-compatible mode.
Syntax
SA_COMPONENTS.DROP_LEVEL (
policy_name IN VARCHAR,
level_num IN NUMBER
);
Parameters
| Parameter | Description |
|---|---|
| policy_name | The name of the policy. To query the existing policies, query the POLICY_NAME column of the ALL_SA_POLICIES view. |
| level_num | The number of the existing level of the policy. To query the existing level numbers, query the LEVEL_NUM column of the ALL_SA_LEVEL view. |
Examples
The following example drops the level with number 500 from the shield_agent_policy policy.
BEGIN
SA_COMPONENTS.DROP_LEVEL (
policy_name => 'shield_agent_policy',
level_num => 500);
END;
/