eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: MDSYS.USER_SDO_INDEX_METADATA

Object Details

Object Name:	USER_SDO_INDEX_METADATA
Object Type:	VIEW
Owner:	MDSYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
SDO_INDEX_OWNER	VARCHAR2	(32)
SDO_INDEX_TYPE	VARCHAR2	(32)
SDO_LEVEL	NUMBER
SDO_NUMTILES	NUMBER
SDO_MAXLEVEL	NUMBER
SDO_COMMIT_INTERVAL	NUMBER
SDO_INDEX_TABLE	VARCHAR2	(32)
SDO_INDEX_NAME	VARCHAR2	(32)
SDO_INDEX_PRIMARY	NUMBER
SDO_TSNAME	VARCHAR2	(32)
SDO_COLUMN_NAME	VARCHAR2	(2048)
SDO_RTREE_HEIGHT	NUMBER
SDO_RTREE_NUM_NODES	NUMBER
SDO_RTREE_DIMENSIONALITY	NUMBER
SDO_RTREE_FANOUT	NUMBER
SDO_RTREE_ROOT	VARCHAR2	(32)
SDO_RTREE_SEQ_NAME	VARCHAR2	(32)
SDO_FIXED_META	RAW	(255)
SDO_TABLESPACE	VARCHAR2	(32)
SDO_INITIAL_EXTENT	VARCHAR2	(32)
SDO_NEXT_EXTENT	VARCHAR2	(32)
SDO_PCTINCREASE	NUMBER
SDO_MIN_EXTENTS	NUMBER
SDO_MAX_EXTENTS	NUMBER
SDO_INDEX_DIMS	NUMBER
SDO_LAYER_GTYPE	VARCHAR2	(32)
SDO_RTREE_PCTFREE	NUMBER
SDO_INDEX_PARTITION	VARCHAR2	(32)
SDO_PARTITIONED	NUMBER
SDO_RTREE_QUALITY	NUMBER
SDO_INDEX_VERSION	NUMBER
SDO_INDEX_GEODETIC	VARCHAR2	(8)
SDO_INDEX_STATUS	VARCHAR2	(32)
SDO_NL_INDEX_TABLE	VARCHAR2	(33)
SDO_DML_BATCH_SIZE	NUMBER
SDO_RTREE_ENT_XPND	NUMBER
SDO_NUM_ROWS	NUMBER
SDO_NUM_BLKS	NUMBER
SDO_OPTIMIZED_NODES	NUMBER
SDO_ROOT_MBR	SDO_GEOMETRY	(64)

Query Text

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


SELECT SDO_INDEX_OWNER
,      SDO_INDEX_TYPE
,      SDO_LEVEL
,      SDO_NUMTILES
,      SDO_MAXLEVEL
,      SDO_COMMIT_INTERVAL
,      SDO_INDEX_TABLE
,      SDO_INDEX_NAME
,      SDO_INDEX_PRIMARY
,      SDO_TSNAME
,      SDO_COLUMN_NAME
,      SDO_RTREE_HEIGHT
,      SDO_RTREE_NUM_NODES
,      SDO_RTREE_DIMENSIONALITY
,      SDO_RTREE_FANOUT
,      SDO_RTREE_ROOT
,      SDO_RTREE_SEQ_NAME
,      SDO_FIXED_META
,      SDO_TABLESPACE
,      SDO_INITIAL_EXTENT
,      SDO_NEXT_EXTENT
,      SDO_PCTINCREASE
,      SDO_MIN_EXTENTS
,      SDO_MAX_EXTENTS
,      SDO_INDEX_DIMS
,      SDO_LAYER_GTYPE
,      SDO_RTREE_PCTFREE
,      SDO_INDEX_PARTITION
,      SDO_PARTITIONED
,      SDO_RTREE_QUALITY
,      SDO_INDEX_VERSION
,      SDO_INDEX_GEODETIC
,      SDO_INDEX_STATUS
,      SDO_NL_INDEX_TABLE
,      SDO_DML_BATCH_SIZE
,      SDO_RTREE_ENT_XPND
,      SDO_NUM_ROWS
,      SDO_NUM_BLKS
,      SDO_OPTIMIZED_NODES
,      SDO_ROOT_MBR
FROM MDSYS.USER_SDO_INDEX_METADATA;

Dependencies

[top of page]

MDSYS.USER_SDO_INDEX_METADATA references the following:

MDSYS: SDO_GEOMETRY; SDO_INDEX_METADATA_TABLE
PUBLIC: USER_INDEXES
SYS: STANDARD - show dependent code

MDSYS.USER_SDO_INDEX_METADATA is referenced by following:

MDSYS: USER_SDO_INDEX_INFO
PUBLIC: SDO_INDEX_METADATA; USER_SDO_INDEX_METADATA