[Home] [Help] [Dependency Information]
Object Name: | ALL_SDO_INDEX_INFO |
---|---|
Object Type: | VIEW |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SDO_INDEX_OWNER | VARCHAR2 | (32) | ||
INDEX_NAME | VARCHAR2 | (32) | ||
TABLE_OWNER | VARCHAR2 | (128) | Yes | |
TABLE_NAME | VARCHAR2 | (128) | Yes | |
COLUMN_NAME | VARCHAR2 | (2048) | ||
SDO_INDEX_TYPE | VARCHAR2 | (32) | ||
SDO_INDEX_TABLE | VARCHAR2 | (32) | ||
SDO_INDEX_STATUS | VARCHAR2 | (32) |
Cut, paste (and edit) the following text to query this object:
SELECT SDO_INDEX_OWNER
, INDEX_NAME
, TABLE_OWNER
, TABLE_NAME
, COLUMN_NAME
, SDO_INDEX_TYPE
, SDO_INDEX_TABLE
, SDO_INDEX_STATUS
FROM MDSYS.ALL_SDO_INDEX_INFO;
|
|
|