Re: How to view a specific index

• Post for FREE via your newsreader at post.usenet.com ****

> How do you see all the information on how it was set up?
> Like storage, the extents, space.

If you are on 9.2. or 10.1 you can use DBMS_METADATA to extract all information in a single and simple statement. e.g.:

SQL> SELECT dbms_metadata.get_ddl('INDEX','PK_DEPT','SCOTT') FROM dual;

DBMS_METADATA.GET_DDL('INDEX','PK_DEPT','SCOTT')

  CREATE UNIQUE INDEX "SCOTT"."PK_DEPT" ON "SCOTT"."DEPT" ("DEPTNO")   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)   TABLESPACE "SYSTEM" Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=