Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

There is no file audit in adump directory

983155Jan 6 2013 — edited Jan 7 2013
Dear 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2013
Added on Jan 6 2013
8 comments
2,599 views