Re: Table Statistics Without Analyzing

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 23 Sep 2002 20:47:14 +0100
Message-ID: <3d8f6fc4$0$1292$cc9e4d1f@news.dial.pipex.com>

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3D8F613D.6CCA_at_yahoo.com...

> I'm dying to know secret object "user_tabes" is :-)

just the restricted version of dba_tabes obviously. doh!

also you'll need

*_objcets
*_tabelspaces
*_tablespacxes (usually immediately after the foregoing)
*$sesssion

etc :(

How all the reference books manage without these objects I'll never know.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

Received on Mon Sep 23 2002 - 14:47:14 CDT