[Home] [Help] [Dependency Information]

TABLE: MDSYS.SDO_NETWORK_METADATA_TABLE

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Unique Key: UNIQUE_LRS_GEOM_LAYER

1. SDO_OWNER
2. NETWORK
3. LRS_TABLE_NAME

Unique Key: UNIQUE_NETWORK_LAYER

1. SDO_OWNER
2. NETWORK

Unique Key: UNIQUE_NETWORK_LINK_LAYER

1. SDO_OWNER
2. NETWORK
3. LINK_TABLE_NAME

Unique Key: UNIQUE_NETWORK_NODE_LAYER

1. SDO_OWNER
2. NETWORK
3. NODE_TABLE_NAME

Unique Key: UNIQUE_NETWORK_PATH_LAYER

1. SDO_OWNER
2. NETWORK
3. PATH_TABLE_NAME

Unique Key: UNIQUE_NETWORK_PATH_LINK_LAYER

1. SDO_OWNER
2. NETWORK
3. PATH_LINK_TABLE_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
UNIQUE_LRS_GEOM_LAYER	NORMAL	UNIQUE	SYSTEM	SDO_OWNER NETWORK LRS_TABLE_NAME
UNIQUE_NETWORK_LAYER	NORMAL	UNIQUE	SYSTEM	SDO_OWNER NETWORK
UNIQUE_NETWORK_LINK_LAYER	NORMAL	UNIQUE	SYSTEM	SDO_OWNER NETWORK LINK_TABLE_NAME
UNIQUE_NETWORK_NODE_LAYER	NORMAL	UNIQUE	SYSTEM	SDO_OWNER NETWORK NODE_TABLE_NAME
UNIQUE_NETWORK_PATH_LAYER	NORMAL	UNIQUE	SYSTEM	SDO_OWNER NETWORK PATH_TABLE_NAME
UNIQUE_NETWORK_PATH_LINK_LAYER	NORMAL	UNIQUE	SYSTEM	SDO_OWNER NETWORK PATH_LINK_TABLE_NAME

Columns

Query Text

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

SELECT SDO_OWNER
,      NETWORK
,      NETWORK_ID
,      NETWORK_CATEGORY
,      GEOMETRY_TYPE
,      NETWORK_TYPE
,      NO_OF_HIERARCHY_LEVELS
,      NO_OF_PARTITIONS
,      LRS_TABLE_NAME
,      LRS_GEOM_COLUMN
,      NODE_TABLE_NAME
,      NODE_GEOM_COLUMN
,      NODE_COST_COLUMN
,      LINK_TABLE_NAME
,      LINK_GEOM_COLUMN
,      LINK_DIRECTION
,      LINK_COST_COLUMN
,      PATH_TABLE_NAME
,      PATH_GEOM_COLUMN
,      PATH_LINK_TABLE_NAME
,      PARTITION_TABLE_NAME
,      NODE_PARTITION_COLUMN
,      LINK_PARTITION_COLUMN
,      NODE_DURATION_COLUMN
,      LINK_DURATION_COLUMN
,      TOPOLOGY
,      USER_DEFINED_DATA
,      EXTERNAL_REFERENCES
,      SUBPATH_TABLE_NAME
,      SUBPATH_GEOM_COLUMN
,      PARTITION_BLOB_TABLE_NAME
,      COMPONENT_TABLE_NAME
,      NODE_LEVEL_TABLE_NAME
,      CHILD_NETWORK
,      HIERARCHY_TABLE_NAME
FROM MDSYS.SDO_NETWORK_METADATA_TABLE;

Dependencies

[top of page]

MDSYS.SDO_NETWORK_METADATA_TABLE does not reference any database object

MDSYS.SDO_NETWORK_METADATA_TABLE is referenced by following:

MDSYS

ALL_SDO_NETWORK_METADATA

SDO_NETWORK_TRIG_DEL

SDO_NETWORK_TRIG_INS

SDO_NETWORK_TRIG_UPD

USER_SDO_NETWORK_METADATA