There is no file audit in adump directory
983155Jan 6 2013 — edited Jan 7 2013Dear All,
I have an issue when I enable auditing feature in oracle,
I use 'DB' to store the audit from user in oracle, my command is
SQL>alter system set audit_trail=db scope=spfile;
SQL>shutdown immediate;
SQL>startup;
in show parameter audit, I see that the audit_trail already changed to DB
after I create a user and enable audit for this user, I can see in the audit table dba_audit_trail for insert, update, delete,etc
but If I am not wrong, if I using DB to setting the audit parameter then I will get audit file both in oracle table and in adump oracle folder installation, but in my case I cannot find any file in adump directory
my operating system is windows7 and I use oracle database 10g express edition,
Is there any sintax that I have not typed it ?
please advice,
thanks & regards,
achmad