Re: when was the last time table accessed

I guess the classic answer to this would be to employ database auditing
AUDIT SELECT ON 

This may not be what you want, but you don't give the business reason behind 
the technical request. 

On 4/18/05, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote:
> 
> Hello All,
> 
> How can I know that when was the last time a table has accessed or had
> any DML operations, in oracle 8i version.
> 
> --=20
> Best Regards,
> Jaffar, OCP DBA
> Banque Saudi Fransi
> Saudi Arabia
> 
> ---------------------------------------------------------------------------=
> -------------
> "It is your atittude, not your aptitude that determins your altitude."
> --
> http://www.freelists.org/webpage/oracle-l
> 



-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

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

Other related posts: