Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to view a specific index

How to view a specific index

From: Laura <handl_at_mts.net>
Date: 19 Jul 2004 14:48:20 -0700
Message-ID: <e0ddcf8.0407191348.37e80f38@posting.google.com> 





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?
Received on Mon Jul 19 2004 - 16:48:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US