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_at_gmail.com> 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