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


TABLE: MDSYS.SDO_NETWORK_TIMESTAMPS

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Unique Key: NETWORK_TIMESTAMP_CONSTRAINT
  1. ColumnOWNER
  2. ColumnNETWORK
  3. ColumnTABLE_NAME
Indexes
Index Type Uniqueness Tablespace Column
NETWORK_TIMESTAMP_CONSTRAINT NORMAL UNIQUE TablespaceSYSAUX ColumnOWNER
ColumnNETWORK
ColumnTABLE_NAME
SDO_NET_TIME_NET NORMAL NONUNIQUE TablespaceSYSAUX ColumnNETWORK
SDO_NET_TIME_OWNER NORMAL NONUNIQUE TablespaceSYSAUX ColumnOWNER
SDO_NET_TIME_TAB NORMAL NONUNIQUE TablespaceSYSAUX ColumnTABLE_NAME
Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (32) Yes
NETWORK VARCHAR2 (24) Yes
TABLE_NAME VARCHAR2 (32) Yes
LAST_DML_TIME TIMESTAMP(6) (11) Yes
Query Text

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


SELECT OWNER
,      NETWORK
,      TABLE_NAME
,      LAST_DML_TIME
FROM MDSYS.SDO_NETWORK_TIMESTAMPS;

Dependencies

[top of page]

MDSYS.SDO_NETWORK_TIMESTAMPS does not reference any database object

MDSYS.SDO_NETWORK_TIMESTAMPS is referenced by following:

SchemaMDSYS
ViewALL_SDO_NETWORK_TIMESTAMPS
TriggerSDO_NETWORK_TIME_DEL_TRIG
TriggerSDO_NETWORK_TIME_INS_TRIG
TriggerSDO_NETWORK_TIME_UPD_TRIG
ViewUSER_SDO_NETWORK_TIMESTAMPS