Is there a way to find out whether a Table was modified in certain
period(E.g.Between 16-Apr-2005,10 am and 17-Apr-2005,9 am)? We could
see that there are records added/modified in a Table. But, we would
like to confirm whether there was any change in the Table in a certain
period of time. Could anybody help here?

qazmlp1209 (AT) rediffmail (DOT) com wrote:
last_ddl_time column is a date. Query all_objects, if you mean a change
in the table is that (and not a change in the *data* of that table)
--
Regards,
Frank van Bortel

Thanks!
But, what I am interested to know is about the time that 'data' of the
Table gets changed. Is there a way to check it?

On 25 May 2005 23:32:20 -0700, qazmlp1209 (AT) rediffmail (DOT) com wrote:

If you would like to audit the data, you can check out an article I
wrote: http://blogs.ittoolbox.com/oracle/gu...ves/003898.asp

You do need to turn auditing on BEFORE the incident that you're trying
to track down.

I hope I understood your question.

LewisC


-----------------------------------------------------------
Lewis R Cunningham

Author, ItToolBox Blog: An Expert's Guide to Oracle
http://blogs.ittoolbox.com/oracle/guide/

Topic Editor, Suite101.com: Oracle Database
http://www.suite101.com/welcome.cfm/oracle

Sign up for courses here:
http://www.suite101.com/suiteu/default.cfm/416752
-----------------------------------------------------------