Re: Table last access date?

You can fetch the last time some table's block has been updated by fetching: select max(ora_rowscn) from my_tab;

You can always convert scn to timestamp

select max(scn_to_timestamp(ora_rowscn)) from my_tab;

Michael

On Wed, Nov 19, 2008 at 4:19 PM, SHEEHAN, JEREMY <JEREMY.SHEEHAN_at_fpl.com>wrote:

> Does anyone have a way to find out the last time a table was last
> accessed? It's something that needs to be figured out for my work and I
> wanted to know if anyone has a way to figure this out. If impossible or an
> incredible stretch just let me know!
>
>
>
> Thanks!
>
>
>
> Jeremy
>

-- 
Best Regards
Michael Elkin

--
http://www.freelists.org/webpage/oracle-l