SV: Recently changed table

From: Jesper Haure Norrevang <jhn.aida_at_cbs.dk>
Date: Mon, 31 Jan 2005 07:49:39 +0100
Message-id: <000001c50761$0979b340$4a28e282@AIDA.local>

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%- views.

Hope this helps.

Regards
Jesper Haure Norrevang

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 31 2005 - 01:52:20 CST