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_COORD_OP_METHODS

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: COORD_OP_METHOD_PRIM

COORD_OP_METHOD_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
COORD_OP_METHOD_PRIM	NORMAL	UNIQUE	SYSTEM	COORD_OP_METHOD_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
SDO_COORD_OPS	SDO_COORD_OP_METHODS	SDO_COORD_OPS COORD_OP_METHOD_ID
SDO_COORD_OP_PARAM_USE	SDO_COORD_OP_METHODS	SDO_COORD_OP_PARAM_USE COORD_OP_METHOD_ID
SDO_COORD_OP_PARAM_VALS	SDO_COORD_OP_METHODS	SDO_COORD_OP_PARAM_VALS COORD_OP_METHOD_ID

Columns

Name	Datatype	Length	Mandatory
COORD_OP_METHOD_ID	NUMBER	(10)	Yes
COORD_OP_METHOD_NAME	VARCHAR2	(50)
LEGACY_NAME	VARCHAR2	(50)
REVERSE_OP	NUMBER	(1)	Yes
INFORMATION_SOURCE	VARCHAR2	(254)
DATA_SOURCE	VARCHAR2	(40)
IS_IMPLEMENTED_FORWARD	NUMBER	(1)	Yes
IS_IMPLEMENTED_REVERSE	NUMBER	(1)	Yes

Query Text

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


SELECT COORD_OP_METHOD_ID
,      COORD_OP_METHOD_NAME
,      LEGACY_NAME
,      REVERSE_OP
,      INFORMATION_SOURCE
,      DATA_SOURCE
,      IS_IMPLEMENTED_FORWARD
,      IS_IMPLEMENTED_REVERSE
FROM MDSYS.SDO_COORD_OP_METHODS;

Dependencies

[top of page]

MDSYS.SDO_COORD_OP_METHODS does not reference any database object

MDSYS.SDO_COORD_OP_METHODS is referenced by following:

MDSYS: SDO_COORD_OP_METHODS_TRIGGER; SDO_CS - show dependent code
PUBLIC: SDO_COORD_OP_METHODS