Reading ORACLE Re-do logs

From: Andrew Jones (lrpr_at_unb.ca) <LRPR_at_UNB.CA>
Date: Tue, 14 Sep 1993 15:58:48 GMT
Message-ID: <14SEP93.12938658.0223_at_UNBVM1.CSD.UNB.CA>

   Does anyone know if there's a way to generate a report or file from the re-do logs for an ORACLE V6 database?

   We'd like to be able to have a
record of what was done when, and by what user. It appears that ORACLE auditing only says what operation was done when and by whom, but not the data content of the insert/delete/replace. The CASE tool will generate this type of log, but it's all in the application code, and that doesn't do much good if someone manages to connect to the database with a homegrown application or in an SQL interactive interface.

    That information must be in the re-do log, and I'd expected that ORACLE (like INGRES) would be able to report the content to me using a vendor-supplied utility; but no such luck. Now I'm looking for someone's homegrown solution, or a commercial product.

    Thanks in advance.

  Andrew Jones (LRPR_at_UNB.CA) "##include <standard disclaimer>"

---

| "Give up, Earthlings! Your superior |
| intelligence is no match for our puny |
| weapons!" |
| (The Simpsons' Halloween II Aliens) |

---

Received on Tue Sep 14 1993 - 17:58:48 CEST