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_PARAMS

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: COORD_OP_PARA_PRIM

PARAMETER_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
COORD_OP_PARA_PRIM	NORMAL	UNIQUE	SYSTEM	PARAMETER_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
SDO_COORD_OP_PARAM_USE		SDO_COORD_OP_PARAMS	SDO_COORD_OP_PARAM_USE PARAMETER_ID
SDO_COORD_OP_PARAM_VALS		SDO_COORD_OP_PARAMS	SDO_COORD_OP_PARAM_VALS PARAMETER_ID

Columns

Name	Datatype	Length	Mandatory
PARAMETER_ID	NUMBER	(10)	Yes
PARAMETER_NAME	VARCHAR2	(80)
INFORMATION_SOURCE	VARCHAR2	(254)
DATA_SOURCE	VARCHAR2	(40)
UNIT_OF_MEAS_TYPE	VARCHAR2	(50)

Query Text

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


SELECT PARAMETER_ID
,      PARAMETER_NAME
,      INFORMATION_SOURCE
,      DATA_SOURCE
,      UNIT_OF_MEAS_TYPE
FROM MDSYS.SDO_COORD_OP_PARAMS;

Dependencies

[top of page]

MDSYS.SDO_COORD_OP_PARAMS does not reference any database object

MDSYS.SDO_COORD_OP_PARAMS is referenced by following:

MDSYS: SDO_CS - show dependent code
PUBLIC: SDO_COORD_OP_PARAMS