CODEWITHSUNDEEP
databaseoracle-databaselogging
IAdapter
IAdapter

Reputation: 64925

How to see Oracle Table Logs?

I look at a table's properties in Oracle and it has "LOGGING: YES". How can I query that log, or if it's in a file, where can I find it?

Upvotes: 0

Views: 27839

Answers (3)

Mark Brady
Mark Brady

Reputation:

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.

Upvotes: 0

Matthew Watson
Matthew Watson

Reputation: 14253

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

Upvotes: 1

David Aldridge
David Aldridge

Reputation: 52396

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.

Upvotes: 1

Related Questions