REMOVE_EXTRACT_RULE

The REMOVE_EXTRACT_RULE procedure removes an extraction rule from the specified policy given a rule_id. Only the owner of the specified policy can remove an extraction rule from the policy. Removal of the extraction rule will be in effect after running CTX_ENTITY.COMPILE.

Syntax

CTX_ENTITY.REMOVE_EXTRACT_RULE(
  policy_name                 IN VARCHAR2,
  rule_id                     IN INTEGER
);

policy_name

Remove the extraction rule from the specified policy.

rule_id

Specify the rule ID of the extraction rule to be removed.

Example

The following example removes the extraction rule with ID 1 from the policy pol1:

exec ctx_entity.remove_extract_rule('pol1', 1);