[Home] [Help] [Dependency Information]
Object Name: | BIM_ALL_INDEXES |
---|---|
Object Type: | TABLE |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
This table store all the index name
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | schema owner of the index | |
INDEX_NAME | VARCHAR2 | (30) | index name | |
TABLE_NAME | VARCHAR2 | (30) | table name on which the index is created for | |
COLUMN_NAME | VARCHAR2 | (3000) | column name on which the index is created | |
PCT_FREE | NUMBER | parameters from all_indexes table | ||
INI_TRANS | NUMBER | parameters from all_indexes table | ||
MAX_TRANS | NUMBER | parameters from all_indexes table | ||
INITIAL_EXTENT | NUMBER | parameters from all_indexes table | ||
NEXT_EXTENT | NUMBER | parameters from all_indexes table | ||
MIN_EXTENTS | NUMBER | parameters from all_indexes table | ||
MAX_EXTENTS | NUMBER | parameters from all_indexes table | ||
PCT_INCREASE | NUMBER | parameters from all_indexes table | ||
UNIQUENESS | VARCHAR2 | (9) | whether the index is unique or not | |
INDEX_TABLESPACE | VARCHAR2 | (30) | tablespace for the index |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, INDEX_NAME
, TABLE_NAME
, COLUMN_NAME
, PCT_FREE
, INI_TRANS
, MAX_TRANS
, INITIAL_EXTENT
, NEXT_EXTENT
, MIN_EXTENTS
, MAX_EXTENTS
, PCT_INCREASE
, UNIQUENESS
, INDEX_TABLESPACE
FROM BIM.BIM_ALL_INDEXES;
BIM.BIM_ALL_INDEXES does not reference any database object
BIM.BIM_ALL_INDEXES is referenced by following:
|
|
|