Oracle Database Discussions

Hi,

I have a newly installed Oracle 12c SE with default mixed mode. Default 2 policies ORA_SECURECONFIG and ORA_LOGIN_FAILURES are enabled. Show parameter audit output and Unified Auditing value v$option as below

SQL> show parameter audit

NAME                                 TYPE        VALUE

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

audit_file_dest                      string      /oracledev/admin/xxxxxx/adump

audit_sys_operations                 boolean     TRUE

audit_syslog_level                   string

audit_trail                          string      DB

unified_audit_sga_queue_size         integer     1048576

SQL> select value from v$option where PARAMETER='Unified Auditing';

VALUE

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

FALSE

I tried a few login failure and create user actions and found the corresponding records in unified_audit_trail but I am not able to find any record for "Create table", "Alter table" or "Drop table" action. What have I done wrong? Can someone help please?