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: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: UNIQUE_TABLES
  1. ColumnSDO_OWNER
  2. ColumnSDO_TABLE_NAME
  3. ColumnSDO_COLUMN_NAME
Indexes
Index Type Uniqueness Tablespace Column
UNIQUE_TABLES NORMAL UNIQUE TablespaceSYSTEM ColumnSDO_OWNER
ColumnSDO_TABLE_NAME
ColumnSDO_COLUMN_NAME
SDO_LRS_META_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnSDO_OWNER
ColumnSDO_TABLE_NAME
Columns
Name Datatype Length Mandatory Comments
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:

SchemaMDSYS
ViewALL_SDO_LRS_METADATA
TriggerSDO_LRS_TRIG_DEL
TriggerSDO_LRS_TRIG_INS
TriggerSDO_LRS_TRIG_UPD
ViewUSER_SDO_LRS_METADATA