Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to view a specific index
> 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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=