Re: Finding out when a table or index was last analysed

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/11
Message-ID: <396B2EF4.5B39@yahoo.com>#1/1

Sybrand Bakker wrote:
>
> User_tables and user_indexes, provided you have 8i
> In 7.3.4 it is definitely not captured, I'm not sure about 8.0.
> Please always specify version and platform.
> Version differences are getting bigger and bigger, it is a bore to outline
> procedures for three different versions.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> "Keith Jamieson" <jamiesonk_at_phoenix.ie> wrote in message
> news:8kffr5$pk3$1_at_kermit.esat.net...
> > Which table or view do I need to look in to find out when a table or index
> > was last analysed.
> >
> > TIA
> >
> > Keith
> >
> >

In 7.3.x, isn't it contained in USER_TAB_COLUMNS ?

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Tue Jul 11 2000 - 00:00:00 CDT