Database Administration (MOSC)

MOSC Banner

Scheduler job question/issue

edited Aug 13, 2024 2:59PM in Database Administration (MOSC) 6 commentsAnswered ✓

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'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center