iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Complete Syntax  |  Oracle Functions  |  PL/SQL Syntax  |  SQL Syntax  |  Tables

 

Oracle Dictionary Tables

ALL_  |  DBA_  |  USER_  |  GV$  |  V$  |  Others

2PC... | APP... | CAP... | EXP... | HIS... | HIS... | IND... | LOC... | OPA... | REC... | REP... | SCH... | STR... | TAB...

 

DBA_INDEXES: Description for all indexes in the database

 

iSelfSchooling-SQL> desc DBA_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                             VARCHAR2(11)

 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