[Home] [Help] [Dependency Information]
Object Name: | BIM_ALL_INDEXES# |
---|---|
Object Type: | VIEW |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | ||
INDEX_NAME | VARCHAR2 | (30) | ||
TABLE_NAME | VARCHAR2 | (30) | ||
COLUMN_NAME | VARCHAR2 | (3000) | ||
PCT_FREE | NUMBER | |||
INI_TRANS | NUMBER | |||
MAX_TRANS | NUMBER | |||
INITIAL_EXTENT | NUMBER | |||
NEXT_EXTENT | NUMBER | |||
MIN_EXTENTS | NUMBER | |||
MAX_EXTENTS | NUMBER | |||
PCT_INCREASE | NUMBER | |||
UNIQUENESS | VARCHAR2 | (9) | ||
INDEX_TABLESPACE | VARCHAR2 | (30) |
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#;
|
|
|