Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table Modification Stamp???
dba_objects contains this sort of stuff
Alex
tim.mcconechy_at_runtime.dk wrote:
> Is there any way to see if a table has been modified.
> Via a certain date or stamp or something.
>
> All I want is to see if a table has changed at some
> point since a specific date.
>
> For example:
> I have a largish table 2000 records that is slow to open.
> I need the whole table in my app.
> I can make the table locally in a Foxpro table
> and only update it when the server table has changed which is not that often.
>
> SO it could check for example a modification date and
> If it has changed since the last check begin to update the local table.
> Otherwise use the local copy.
>
> Any other ideas...
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Feb 17 1999 - 03:55:02 CST