SV: Recently changed table

  • From: Jesper Haure Norrevang <jhn.aida@xxxxxx>
  • To: jacintakean@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 31 Jan 2005 07:49:39 +0100

Goodmorning Jacinta,

> I need to know , in oracle - Is there a way i can
> determine those recently changed table at a given
> time?

If you need to know, who did a change to data at a
known point in time, then Mladen already said that
AUDIT or trigges are the answers.

If things went wrong one week ago and you did not
audit the action at that time, then Oracle LogMiner
can help you to use the archivelogs to see
- who did the change
- how to undo the change
- how to redo the change
- when was it done.

See chapter 9 in Oracle9i, Database Administrators
Guide, Release 2 (9.2).

Check the DBMS_LOGMNR-package and the v$LOGMNR%-

Hope this helps.

Jesper Haure Norrevang


Other related posts:

  • » SV: Recently changed table