Re: Oracle Redo Logs

carlo_at_crai.crai.it wrote:
: Hello,
 

: I am not familiar with Oracle.
: My company owns two different Oracle versions (V6 and V7).
: I have to implement a user process that needs know the SQL operations
: performed on a specified table by several transactions.
: Probably this process has to access the Oracle Log.
 

: Could somebody please let me know: 1) how can a user program access the Oracle log? and 2) what is the log record structure (schema)?
 

: Thank you in advance.
 

: Carlo

I would be very surprised if you could make any sense from the content of the Oracle redo logs, they contain logical records whcih are relevant only to the file#, block# and row#, with after image data.

In Oracle 6 this is going to be very difficult. In Oracle 7 it is easy. You only need to declare database triggers on the tables you are worried about, one trigger for inserts, updates, dletes and query. This will allow you to monitor the sql done on a particular table. Other options include Trusted Oracle.

Jon Pope					|jpope_at_balrog.europe.dg.com
Data General UK Ltd				|jon_pope_at_DGE.ceo.dg.com
UK RDB Consultant, Oracle Kernel Specialist	|

Doom, DOTT, FOA, XWING, STS - who needs work?