Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Finding table modification timings(not just the last one)

Re: Finding table modification timings(not just the last one)

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 17 May 2005 11:33:16 +0200
Message-ID: <d6cdgi$als$1@news4.zwoll1.ov.home.nl>


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 Bortel
Received on Tue May 17 2005 - 04:33:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US