Re: How to view a specific index

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.