Extract Auditing Information from Oracle Server.

From: <tjmxyz_at_my-deja.com>
Date: Mon, 02 Aug 1999 14:32:13 GMT
Message-ID: <7o4a5d$lro$1@nnrp1.deja.com>

Hi!

Our system has a logging system that records basically which records have changed what in which databse.

It was built in Foxpro and I kept it the way it is for a fast rewrite to Oracle...

Problem is I see it as very slow because I can not save in bulk I must save row by row...

So the procedure goes in the worst cases.. FOR i=1 to Number_of_table_records DO
  SAVE THE RECORD
  LOG THE CHANGE TO SEPERATE LOG TABLE
  SAVE THE CHANGE NUMBER TO MAIN TABLE
END FOR SO I was thinking about using Oracles Auditing as a replacement for the log table as it must store the same thing:

I would like to extract the following information: A Uniue key of somekind to reference the record... USER,TABLE,TYPE (delete, update ect..)
,TIME,MAINKEY in the saved table
Old and new value.

How can I go about doing this or is it even possible?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 02 1999 - 09:32:13 CDT