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]

TABLE: MDSYS.SDO_INDEX_METADATA_TABLE

Object Details

Object Name:	SDO_INDEX_METADATA_TABLE
Object Type:	TABLE
Owner:	MDSYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000021505C00045$$	LOB	UNIQUE	SYSTEM
SYS_IL0000021505C00046$$	LOB	UNIQUE	SYSTEM
SDO_IDX_MDATA_IDX	NORMAL	NONUNIQUE	SYSAUX	SDO_INDEX_OWNER SDO_INDEX_NAME SDO_INDEX_PARTITION

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_ROOT_MBR	SDO_GEOMETRY	(1)
SDO_OPTIMIZED_NODES	NUMBER

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_ROOT_MBR
,      SDO_OPTIMIZED_NODES
FROM MDSYS.SDO_INDEX_METADATA_TABLE;

Dependencies

[top of page]

MDSYS.SDO_INDEX_METADATA_TABLE references the following:

MDSYS: SDO_ELEM_INFO_ARRAY; SDO_GEOMETRY; SDO_ORDINATE_ARRAY
SYS: STANDARD - show dependent code

MDSYS.SDO_INDEX_METADATA_TABLE is referenced by following:

MDSYS: ALL_SDO_INDEX_METADATA; MDPRVT_IDX - show dependent code; MY_SDO_INDEX_METADATA; SDO_INDEX_METADATA_UPDATE; USER_SDO_INDEX_METADATA