The SA_COMPONENTS.DROP_LEVEL procedure is used to drop a level.
If the level is used in existing tags, it cannot be dropped.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
SA_COMPONENTS.DROP_LEVEL (
policy_name IN VARCHAR,
level_num IN NUMBER
);
Parameters
| Parameter | Description |
|---|---|
| policy_name | The name of the policy. To find the name of an existing policy, query the POLICY_NAME column of the ALL_SA_POLICIES view. |
| level_num | The number of the existing level of the policy. To find the number of an existing level, query the LEVEL_NUM column of the ALL_SA_LEVEL view. |
Examples
The following example shows how to drop level 500 of the shield_agent_policy policy.
BEGIN
SA_COMPONENTS.DROP_LEVEL (
policy_name => 'shield_agent_policy',
level_num => 500);
END;
/