Get information on all the indexes you have access to using all_indexes. : all_indexes « System Tables Data Dictionary « Oracle PL/SQL Tutorial

Home
Oracle PL/SQL Tutorial
1.Introduction
2.Query Select
3.Set
4.Insert Update Delete
5.Sequences
6.Table
7.Table Joins
8.View
9.Index
10.SQL Data Types
11.Character String Functions
12.Aggregate Functions
13.Date Timestamp Functions
14.Numerical Math Functions
15.Conversion Functions
16.Analytical Functions
17.Miscellaneous Functions
18.Regular Expressions Functions
19.Statistical Functions
20.Linear Regression Functions
21.PL SQL Data Types
22.PL SQL Statements
23.PL SQL Operators
24.PL SQL Programming
25.Cursor
26.Collections
27.Function Procedure Packages
28.Trigger
29.SQL PLUS Session Environment
30.System Tables Data Dictionary
31.System Packages
32.Object Oriented
33.XML
34.Large Objects
35.Transaction
36.User Privilege
Oracle PL/SQL Tutorial » System Tables Data Dictionary » all_indexes 




SQL>
SQL> desc all_indexes;
 Name                    Null?    Type

 OWNER                   NOT NULL VARCHAR2(30)
 INDEX_NAME              NOT NULL VARCHAR2(30)
 INDEX_TYPE                       VARCHAR2(27)
 TABLE_OWNER             NOT NULL VARCHAR2(30)
 TABLE_NAME              NOT NULL VARCHAR2(30)
 TABLE_TYPE                       CHAR(5)
 UNIQUENESS                       VARCHAR2(9)
 COMPRESSION                      VARCHAR2(8)
 PREFIX_LENGTH                    NUMBER
 TABLESPACE_NAME                  VARCHAR2(30)
 INI_TRANS                        NUMBER
 MAX_TRANS                        NUMBER
 INITIAL_EXTENT                   NUMBER
 NEXT_EXTENT                      NUMBER
 MIN_EXTENTS                      NUMBER
 MAX_EXTENTS                      NUMBER
 PCT_INCREASE                     NUMBER
 PCT_THRESHOLD                    NUMBER
 INCLUDE_COLUMN                   NUMBER
 FREELISTS                        NUMBER
 FREELIST_GROUPS                  NUMBER
 PCT_FREE                         NUMBER
 LOGGING                          VARCHAR2(3)
 BLEVEL                           NUMBER
 LEAF_BLOCKS                      NUMBER
 DISTINCT_KEYS                    NUMBER
 AVG_LEAF_BLOCKS_PER_KEY          NUMBER
 AVG_DATA_BLOCKS_PER_KEY          NUMBER
 CLUSTERING_FACTOR                NUMBER
 STATUS                           VARCHAR2(8)
 NUM_ROWS                         NUMBER
 SAMPLE_SIZE                      NUMBER
 LAST_ANALYZED                    DATE
 DEGREE                           VARCHAR2(40)
 INSTANCES                        VARCHAR2(40)
 PARTITIONED                      VARCHAR2(3)
 TEMPORARY                        VARCHAR2(1)
 GENERATED                        VARCHAR2(1)
 SECONDARY                        VARCHAR2(1)
 BUFFER_POOL                      VARCHAR2(7)
 USER_STATS                       VARCHAR2(3)
 DURATION                         VARCHAR2(15)
 PCT_DIRECT_ACCESS                NUMBER
 ITYP_OWNER                       VARCHAR2(30)
 ITYP_NAME                        VARCHAR2(30)
 PARAMETERS                       VARCHAR2(1000)
 GLOBAL_STATS                     VARCHAR2(3)
 DOMIDX_STATUS                    VARCHAR2(12)
 DOMIDX_OPSTATUS                  VARCHAR2(6)
 FUNCIDX_STATUS                   VARCHAR2(8)
 JOIN_INDEX                       VARCHAR2(3)
 IOT_REDUNDANT_PKEY_ELIM          VARCHAR2(3)
 DROPPED                          VARCHAR2(3)

SQL>
SQL> --select from all_indexes;
SQL>














30.8.all_indexes
30.8.1.Get information on all the indexes you have access to using all_indexes.
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.