Scheduler job question/issue
Hello all,
Running oracle 19.24 ASM cdb/pdb
I am assuming my issue is with how I have the scheduler job configured.
We are trying to purge the unified audit trail and the process runs for hours sometimes days.
The problem is the job seems to be trying to purge records in a partition that is 7 days from run time.
It will drop a partition but how can we stop it from deleting records in a non-droppable partition?
this is the job that does the purge process. This is ran in the PDB
BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'SYS.UNIFIED_AUDIT_ARCHIVE'