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;>>

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.    

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