[Home] [Help] [Dependency Information]

TABLE: MDSYS.SDO_COORD_OPS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: COORD_OP_PRIM

1. COORD_OP_ID

Unique Key: COORD_OP_NAME_UNIQUE

1. COORD_OP_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
COORD_OP_NAME_UNIQUE	NORMAL	UNIQUE	SYSTEM	COORD_OP_NAME
COORD_OP_PRIM	NORMAL	UNIQUE	SYSTEM	COORD_OP_ID
SDO_COORD_OPS_COORD_OP_TYPE	NORMAL	NONUNIQUE	SYSTEM	COORD_OP_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
SDO_COORD_OPS		SDO_COORD_OPS	SDO_COORD_OPS LEGACY_CODE
SDO_COORD_OPS		SDO_COORD_OP_METHODS	SDO_COORD_OPS COORD_OP_METHOD_ID
SDO_COORD_OPS		SDO_COORD_REF_SYS	SDO_COORD_OPS SOURCE_SRID
SDO_COORD_OPS		SDO_COORD_REF_SYS	SDO_COORD_OPS TARGET_SRID
SDO_COORD_OPS		SDO_COORD_OPS	SDO_COORD_OPS LEGACY_CODE
SDO_COORD_OP_PARAM_VALS		SDO_COORD_OPS	SDO_COORD_OP_PARAM_VALS COORD_OP_ID
SDO_COORD_REF_SYS		SDO_COORD_OPS	SDO_COORD_REF_SYS PROJECTION_CONV_ID

Columns

Query Text

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

SELECT COORD_OP_ID
,      COORD_OP_NAME
,      COORD_OP_TYPE
,      SOURCE_SRID
,      TARGET_SRID
,      COORD_TFM_VERSION
,      COORD_OP_VARIANT
,      COORD_OP_METHOD_ID
,      UOM_ID_SOURCE_OFFSETS
,      UOM_ID_TARGET_OFFSETS
,      INFORMATION_SOURCE
,      DATA_SOURCE
,      SHOW_OPERATION
,      IS_LEGACY
,      LEGACY_CODE
,      REVERSE_OP
,      IS_IMPLEMENTED_FORWARD
,      IS_IMPLEMENTED_REVERSE
FROM MDSYS.SDO_COORD_OPS;

Dependencies

[top of page]

MDSYS.SDO_COORD_OPS does not reference any database object

MDSYS.SDO_COORD_OPS is referenced by following:

MDSYS

SDO_AVAILABLE_ELEM_OPS

SDO_AVAILABLE_NON_ELEM_OPS

SDO_COORD_OPS_TRIGGER

SDO_CS - show dependent code

SDO_PROJECTIONS_OLD_FORMAT

PUBLIC

SDO_COORD_OPS