The DROP_PURGE_JOB procedure is used to delete a purge job created by the CREATE_PURGE_JOB procedure. The name of the purge job is passed as a parameter.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_AUDIT_MGMT.DROP_PURGE_JOB(
audit_trail_purge_name IN VARCHAR2) ;
Parameters
audit_trail_purge_name specifies the name of the purge job to be deleted, which is the name of the purge job specified by the CREATE_PURGE_JOB procedure.
Examples
The following example calls the DROP_PURGE_JOB procedure to delete a purge job named MYCLEANUP.
BEGIN
DBMS_AUDIT_MGMT.DROP_PURGE_JOB(
AUDIT_TRAIL_PURGE_NAME => 'MyCLEANUP');
END;