Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Finding table modification timings(not just the last one)
qazmlp1209_at_rediffmail.com wrote:
> 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?
>
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 BortelReceived on Tue May 17 2005 - 04:33:16 CDT