The DROP_PURGE_JOB procedure drops a purge job created with 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 provides only the MySQL mode.
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 dropped, which is the name of the purge job created by using the CREATE_PURGE_JOB procedure.
Examples
The following example calls the DROP_PURGE_JOB procedure to drop the purge job named MYCLEANUP:
BEGIN
DBMS_AUDIT_MGMT.DROP_PURGE_JOB(
AUDIT_TRAIL_PURGE_NAME => 'MyCLEANUP');
END;