How to see Oracle Table Logs ?

Question

I look at table properties in Oracle and it has "LOGGING: YES". how can i query that log or if its in file were can I find it?

Answer 1

Logging on a table just means that all DML on the table will generate REDO, eg, if the server crashes the table will be recoverable. If you have LOGGING turned off, then some types of DML (direct load) will not cause redo, and may not be recoverable after a crash.

This option is something that you would mainly use in a data warehouse I believe.

A good article on it can be found here

Answer 2

I'll echo Matthew's reply, but also add that you can sort-of query the "log" by using the Flashback Query syntax. You're really querying the undo rather than the redo, of course, and performance is nothing spectacular. 11g has significant enhancements.

Answer 3

You can also turn Auditing on. That can audit INS/UPD/DEL/SEL both successes and/or failures. It can write the results to a table or to the file system.