Home » SQL & PL/SQL » SQL & PL/SQL » Audit Database Problem
Audit Database Problem [message #680636] Wed, 27 May 2020 12:13 Go to next message
Messages: 1
Registered: May 2020
Junior Member
Hi all, I want to ask about auditing database.

So I have a problem like this. I have a table that I have audited. Example we called it table x. Audit data in table X is recorded until the 14th. However, on the 15th onwards, no audit data is recorded.

So what is the problem ?
Why it just audited until date of 14th ?
How I can solve this problem ?
Re: Audit Database Problem [message #680637 is a reply to message #680636] Wed, 27 May 2020 12:24 Go to previous message
Michel Cadot
Messages: 67851
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

How do you audit?
If you use the Oracle old or unified audit, audit longs until 1) you tell Oracle to no more audit or 2) you audit on OS file and this one or the file system is full.

Previous Topic: materialized view issue
Next Topic: UTL_MAIL vs UTL_SMTP sending CLOB body
Goto Forum:

Current Time: Tue May 18 00:06:07 CDT 2021