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_REF_SYS

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: COORD_REF_SYSTEM_PRIM

SRID

Indexes

Index	Type	Uniqueness	Tablespace	Column
COORD_REF_SYSTEM_PRIM	NORMAL	UNIQUE	SYSTEM	SRID
SYS_IL0000385415C00022$$	LOB	UNIQUE	SYSTEM
SYS_IL0000385415C00023$$	LOB	UNIQUE	SYSTEM
SDO_COORD_REF_SYS_KIND	NORMAL	NONUNIQUE	SYSTEM	COORD_REF_SYS_KIND

Foreign Keys

Table	Foreign Table	Foreign Key Column
SDO_COORD_REF_SYS	SDO_COORD_OPS	SDO_COORD_REF_SYS PROJECTION_CONV_ID
SDO_COORD_REF_SYS	SDO_COORD_REF_SYS	SDO_COORD_REF_SYS LEGACY_CODE
SDO_COORD_REF_SYS	SDO_COORD_REF_SYS	SDO_COORD_REF_SYS CMPD_HORIZ_SRID
SDO_COORD_REF_SYS	SDO_COORD_REF_SYS	SDO_COORD_REF_SYS CMPD_VERT_SRID
SDO_COORD_REF_SYS	SDO_COORD_REF_SYS	SDO_COORD_REF_SYS SOURCE_GEOG_SRID
SDO_COORD_REF_SYS	SDO_COORD_SYS	SDO_COORD_REF_SYS COORD_SYS_ID
SDO_COORD_REF_SYS	SDO_DATUMS	SDO_COORD_REF_SYS DATUM_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_OP_PATHS	SDO_COORD_REF_SYS	SDO_COORD_OP_PATHS SINGLE_OP_SOURCE_ID
SDO_COORD_OP_PATHS	SDO_COORD_REF_SYS	SDO_COORD_OP_PATHS SINGLE_OP_TARGET_ID
SDO_COORD_REF_SYS	SDO_COORD_REF_SYS	SDO_COORD_REF_SYS CMPD_VERT_SRID
SDO_COORD_REF_SYS	SDO_COORD_REF_SYS	SDO_COORD_REF_SYS CMPD_HORIZ_SRID
SDO_COORD_REF_SYS	SDO_COORD_REF_SYS	SDO_COORD_REF_SYS LEGACY_CODE
SDO_COORD_REF_SYS	SDO_COORD_REF_SYS	SDO_COORD_REF_SYS SOURCE_GEOG_SRID

Columns

Name	Datatype	Length	Mandatory
SRID	NUMBER	(10)	Yes
COORD_REF_SYS_NAME	VARCHAR2	(80)	Yes
COORD_REF_SYS_KIND	VARCHAR2	(24)	Yes
COORD_SYS_ID	NUMBER	(10)
DATUM_ID	NUMBER	(10)
GEOG_CRS_DATUM_ID	NUMBER	(10)
SOURCE_GEOG_SRID	NUMBER	(10)
PROJECTION_CONV_ID	NUMBER	(10)
CMPD_HORIZ_SRID	NUMBER	(10)
CMPD_VERT_SRID	NUMBER	(10)
INFORMATION_SOURCE	VARCHAR2	(254)
DATA_SOURCE	VARCHAR2	(40)
IS_LEGACY	VARCHAR2	(5)	Yes
LEGACY_CODE	NUMBER	(10)
LEGACY_WKTEXT	VARCHAR2	(2046)
LEGACY_CS_BOUNDS	SDO_GEOMETRY	(1)
IS_VALID	VARCHAR2	(5)
SUPPORTS_SDO_GEOMETRY	VARCHAR2	(5)

Query Text

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


SELECT SRID
,      COORD_REF_SYS_NAME
,      COORD_REF_SYS_KIND
,      COORD_SYS_ID
,      DATUM_ID
,      GEOG_CRS_DATUM_ID
,      SOURCE_GEOG_SRID
,      PROJECTION_CONV_ID
,      CMPD_HORIZ_SRID
,      CMPD_VERT_SRID
,      INFORMATION_SOURCE
,      DATA_SOURCE
,      IS_LEGACY
,      LEGACY_CODE
,      LEGACY_WKTEXT
,      LEGACY_CS_BOUNDS
,      IS_VALID
,      SUPPORTS_SDO_GEOMETRY
FROM MDSYS.SDO_COORD_REF_SYS;

Dependencies

[top of page]

MDSYS.SDO_COORD_REF_SYS references the following:

MDSYS: SDO_ELEM_INFO_ARRAY; SDO_GEOMETRY; SDO_ORDINATE_ARRAY
SYS: STANDARD - show dependent code

MDSYS.SDO_COORD_REF_SYS is referenced by following:

MDSYS: GEODETIC_SRIDS; SDO_COORD_OP_PARAM_VAL_TRIGGER; SDO_COORD_REF_SRID_INSERT; SDO_COORD_REF_SRID_UPDATE; SDO_COORD_REF_SYSTEM; SDO_CRS_COMPOUND; SDO_CRS_DELETE_TRIGGER; SDO_CRS_ENGINEERING; SDO_CRS_GEOCENTRIC; SDO_CRS_GEOGRAPHIC2D; SDO_CRS_GEOGRAPHIC3D; SDO_CRS_INSERT_TRIGGER; SDO_CRS_PROJECTED; SDO_CRS_VERTICAL; SDO_CS - show dependent code; SDO_PROJECTIONS_OLD_FORMAT; SDO_UTIL - show dependent code
PUBLIC: SDO_COORD_REF_SYS