RE: Table last access date?
- From: "Michael Fontana" <mfontana@xxxxxxxxxxx>
- To: "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Nov 2008 15:52:57 -0600 (CST)
<<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;>>
While that's a neat trick to identify an update, I believe the goal was
to identify "access", because the requestor was looking for unused tables
to drop.
Other related posts:
