You will have to put a field in the table with a date/time of update. There
is no way that Oracle does this for you. RBG
----- Original Message -----
From: Adam Bisley <ABISLEY_at_invensys-energy.co.nz>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Monday, May 15, 2000 12:14 AM
Subject: How can I
> Find out the last time a table was accessed ? Ie Read From.
>
> regards ..... Adam.
>
> Adam Bisley
> Database Administrator
>
> Invensys Energy Systems (NZ) Limited
> 39 Princess Street,
> PO Box 11-188,
> Christchurch 8030,
> New Zealand
> Phone (+64)3 3433314 Fax (+64)3 3488871
> DDI Phone (+64)3 3437479
> Email abisley_at_invensys-energy.co.nz
> Website www.invensys-energy.co.nz
>
>
> --
> Author: Adam Bisley
> INET: ABISLEY_at_invensys-energy.co.nz
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon May 15 2000 - 08:16:48 CDT
