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: Table Modification Stamp???

Re: Table Modification Stamp???

From: Alex Hudghton <alex.hudghton_at_capgemini.co.uk>
Date: Wed, 17 Feb 1999 09:55:02 +0000
Message-ID: <36CA91F6.355234BF@capgemini.co.uk>


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

Original text of this message

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