Re: How to find out a table last access time-stamp?

On Fri, 25 Mar 2005 11:23:47 +0100, Noel <tbal_at_go2.pll-l> wrote:

>Personally, i would create table TABLE_ACCESS with, table_name,
>last_read_date, last_write_date columns.
>
>Then i would create a script or procedure, which for each table in
>schema create a trigger on it after insert,select,update and delete.
>Trigger just update TABLE_ACCESS table.
>No way in 8.1.7.4 to check system tables for last table access, i think.

Trigger on select? Could you please show me the location of the docs where it is stated you build a trigger on a select?

If the O/P is not interested in the actual sql statement, AUDIT would do the tric.

And in 8.1.7 you have v$access.

--
Sybrand Bakker, Senior Oracle DBA