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_LRS_METADATA_TABLE

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: UNIQUE_TABLES

SDO_OWNER
SDO_TABLE_NAME
SDO_COLUMN_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
UNIQUE_TABLES	NORMAL	UNIQUE	SYSTEM	SDO_OWNER SDO_TABLE_NAME SDO_COLUMN_NAME
SDO_LRS_META_IDX	NORMAL	NONUNIQUE	SYSTEM	SDO_OWNER SDO_TABLE_NAME

Columns

Name	Datatype	Length	Mandatory
SDO_OWNER	VARCHAR2	(32)	Yes
SDO_TABLE_NAME	VARCHAR2	(32)	Yes
SDO_COLUMN_NAME	VARCHAR2	(32)	Yes
SDO_DIM_POS	NUMBER		Yes
SDO_DIM_UNIT	VARCHAR2	(32)

Query Text

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


SELECT SDO_OWNER
,      SDO_TABLE_NAME
,      SDO_COLUMN_NAME
,      SDO_DIM_POS
,      SDO_DIM_UNIT
FROM MDSYS.SDO_LRS_METADATA_TABLE;

Dependencies

[top of page]

MDSYS.SDO_LRS_METADATA_TABLE does not reference any database object

MDSYS.SDO_LRS_METADATA_TABLE is referenced by following:

MDSYS: ALL_SDO_LRS_METADATA; SDO_LRS_TRIG_DEL; SDO_LRS_TRIG_INS; SDO_LRS_TRIG_UPD; USER_SDO_LRS_METADATA