Re: How to view a specific index

Mladen Gogala wrote:
>
> On Mon, 19 Jul 2004 14:48:20 -0700, Laura wrote:
>
> > What is the sql command to view information on a specific index?
> >
> > If the index is
> > ADMIN.LR_ACCOUNT_IDX
> >
> > How do you see all the information on how it was set up?
> > Like storage, the extents, space.
> >
> > Reason is, that I got an error
> > ORA-1632: max # extents 128 reached in index ADMIN.LR_ACCOUNT_IDX
> >
> > Now I wanted to look at it, with out going into DBA studio. Vendor
> > fixed by setting to unlimmited, is this a good thing?
>
> Tables you're looking for are DBA_EXTENTS and DBA_INDEXES
>
> --
> A city is a large community where people are lonesome together.

and DBA_IND_COLUMNS / DBA_IND_EXPRESSIONS

hth

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------