Oracle Database Discussions

SQL> select * from v$version;

BANNER

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

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

PL/SQL Release 11.2.0.1.0 - Production

CORE    11.2.0.1.0      Production

TNS for 32-bit Windows: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

SQL> select audit_option from dba_stmt_audit_opts;

no rows selected

SQL> show parameter audit;

NAME                                 TYPE        VALUE

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

audit_file_dest                      string      C:\APP\ADMINISTRATOR\ADMIN\ORC

                                                 L\ADUMP

audit_sys_operations                 boolean     FALSE

audit_trail                          string      DB

SQL> select count(*) from dba_audit_trail;

  COUNT(*)

----------

      4132

SQL> audit create any table by scott;

Audit succeeded.

SQL> select audit_option from dba_stmt_audit_opts;

AUDIT_OPTION

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

CREATE ANY TABLE

SQL> create table dummy(a number);

Table created.

SQL> insert into dummy values (1);

1 row created.

SQL> commit;

Commit complete.

SQL> select count(*) from dba_audit_trail;

  COUNT(*)

----------

      4132

SQL>

So, my question is why I am not seeing +1 in dba_audit_trail while scott user has been auditing for create any table i.e. before enabling auditing and creating the table there are 4132 rows in dba_audit_trail and they are same even after enabling audit and create the table. Kindly help me to understand it.

Thanks.