Audit doubts
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
-------------------- ---------------------------------------- -------- -------------