Database Administration (MOSC)

MOSC Banner

Audit doubts

edited Apr 28, 2020 10:42AM in Database Administration (MOSC) 7 commentsAnswered ✓

Hi,

I have a database 12.1.0.2 with auditing parameter set as DB.

There are 2 cases that I need help to understand the audit result:

Case 1: I was analyzing audit information related to table T1094 which had been created on 10/12/18  and for some reason, I could not find “create table” neither the last DDL command issued on 28/01/20 from both unified_audit_trail and dba_audit_trail views. Why those DDL commands were missing from the audit views?

select owner, object_name, created, last_ddl_time from dba_objects where object_name = 'T1094'

OWNER                OBJECT_NAME                              CREATED  LAST_DDL_TIME

-------------------- ---------------------------------------- -------- -------------

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