DROP_EXTRACT_POLICY

The DROP_EXTRACT_POLICY procedure drops an extraction policy. These policies can only be dropped by the policy owner. This procedure issues a commit.

Syntax

CTX_ENTITY.DROP_EXTRACT_POLICY(
  policy_name                 IN VARCHAR2
);

policy_name

Specify the name of the extraction policy to be dropped.

Example

The following example drops the extraction policy pol2:

exec ctx_entity.drop_extract_policy('pol2');