DBA Data[Home] [Help] [Dependency Information]


VIEW: MDSYS.USER_SDO_INDEX_INFO

Object Details
Object Name: USER_SDO_INDEX_INFO
Object Type: VIEW
Owner: MDSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INDEX_NAME
,      TABLE_OWNER
,      TABLE_NAME
,      COLUMN_NAME
,      SDO_INDEX_TYPE
,      SDO_INDEX_TABLE
,      SDO_INDEX_STATUS
FROM MDSYS.USER_SDO_INDEX_INFO;

Dependencies

[top of page]

MDSYS.USER_SDO_INDEX_INFO references the following:

SchemaMDSYS
ViewUSER_SDO_INDEX_METADATA
SchemaPUBLIC
SynonymUSER_INDEXES
MDSYS.USER_SDO_INDEX_INFO is referenced by following:

SchemaMDSYS
Package BodyPRVT_PC - show dependent code
SchemaPUBLIC
SynonymUSER_SDO_INDEX_INFO