Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table Modification Stamp???
I presume you mean the data not the table structure.
How about adding a trigger that updates a single row/column table with a timestamp or sequence number. You can then test whether this value has changed. Or have a dummy row on the table that is updated each time a change is made, again via a trigger.
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 - 04:10:11 CST