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!

Log file for database auditing.

dassdhanSep 16 2015 — edited Sep 17 2015

hi,

We are using database 11g.

Please tell me that Is there any log file, which contains every DML/DDL statements.

Actually, so users are connected to our database, and I want to make a table, which records user's activities regarding database changes like computer name,ip address,date, time,dml/ddl statements. For this, I have to make trigger in every tables, which are more than 1000. It is easy,but a process lengthy process.

By some sources I came to know that Oracle itself maintain a log file, which records all the dml/ddl statements.So, please guide me for the same and how can it possible in TOAD.

Thanks.

Regads.

Dass.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2015

Added on Sep 16 2015

#general-database-discussions

5 comments

783 views