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_NETWORK_CONSTRAINTS

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Unique Key: UNIQUE_CLASS_CONSTRAINT

SDO_OWNER
CLASS_NAME

Unique Key: UNIQUE_USER_CONSTRAINT

SDO_OWNER
CONSTRAINT

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000491756C00005$$	LOB	UNIQUE	SYSTEM
UNIQUE_CLASS_CONSTRAINT	NORMAL	UNIQUE	SYSTEM	SDO_OWNER CLASS_NAME
UNIQUE_USER_CONSTRAINT	NORMAL	UNIQUE	SYSTEM	SDO_OWNER CONSTRAINT
SDO_NET_CONS_CLASS	NORMAL	NONUNIQUE	SYSAUX	CLASS_NAME
SDO_NET_CONS_CONS	NORMAL	NONUNIQUE	SYSAUX	CONSTRAINT
SDO_NET_CONS_OWNER	NORMAL	NONUNIQUE	SYSAUX	SDO_OWNER

Columns

Name	Datatype	Length	Mandatory
SDO_OWNER	VARCHAR2	(32)	Yes
CONSTRAINT	VARCHAR2	(32)	Yes
DESCRIPTION	VARCHAR2	(200)
CLASS_NAME	VARCHAR2	(4000)
CLASS	BLOB	(4000)
JAVA_INTERFACE	VARCHAR2	(4000)

Query Text

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


SELECT SDO_OWNER
,      CONSTRAINT
,      DESCRIPTION
,      CLASS_NAME
,      CLASS
,      JAVA_INTERFACE
FROM MDSYS.SDO_NETWORK_CONSTRAINTS;

Dependencies

[top of page]

MDSYS.SDO_NETWORK_CONSTRAINTS does not reference any database object

MDSYS.SDO_NETWORK_CONSTRAINTS is referenced by following:

MDSYS: ALL_SDO_NETWORK_CONSTRAINTS; ALL_SDO_NETWORK_JAVA_OBJECTS; SDO_NETWORK_CONS_UPD_TRIG; SDO_NETWORK_JAVA_DEL_TRIG; SDO_NETWORK_JAVA_INS_TRIG; SDO_NETWORK_JAVA_UPD_TRIG; USER_SDO_NETWORK_CONSTRAINTS; USER_SDO_NETWORK_JAVA_OBJECTS