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


TABLE: MDSYS.SDO_TOPO_METADATA_TABLE

Object Details
Object Name: SDO_TOPO_METADATA_TABLE
Object Type: TABLE
Owner: MDSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Unique Key: SYS_C00246770
  1. ColumnSYS_NC0000400005$
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00246770 NORMAL UNIQUE TablespaceSYSAUX ColumnTOPO_GEOMETRY_LAYERS
SDO_TOPO_METADATA_IDX NORMAL NONUNIQUE TablespaceSYSAUX ColumnSDO_OWNER
ColumnTOPOLOGY
ColumnTOPOLOGY_ID
Columns
Name Datatype Length Mandatory Comments
SDO_OWNER VARCHAR2 (32)
TOPOLOGY VARCHAR2 (20)
TOPOLOGY_ID NUMBER

TOPO_GEOMETRY_LAYERS SDO_TOPO_GEOMETRY_LAYER_TABLE (16)
TOLERANCE NUMBER

SRID NUMBER

DIGITS_RIGHT_OF_DECIMAL NUMBER

Query Text

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


SELECT SDO_OWNER
,      TOPOLOGY
,      TOPOLOGY_ID
,      TOPO_GEOMETRY_LAYERS
,      TOLERANCE
,      SRID
,      DIGITS_RIGHT_OF_DECIMAL
FROM MDSYS.SDO_TOPO_METADATA_TABLE;

Dependencies

[top of page]

MDSYS.SDO_TOPO_METADATA_TABLE references the following:

SchemaMDSYS
TYPESDO_TOPO_GEOMETRY_LAYER_TABLE
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
MDSYS.SDO_TOPO_METADATA_TABLE is referenced by following:

SchemaMDSYS
ViewALL_SDO_TOPO_INFO
ViewALL_SDO_TOPO_METADATA
Package BodySDO_TOPO_METADATA_INT - show dependent code
ViewUSER_SDO_TOPO_INFO
ViewUSER_SDO_TOPO_METADATA