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_SYS

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: COORDINATE_SYSTEM_PRIM

COORD_SYS_ID

Unique Key: SYS_C00186535

COORD_SYS_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
COORDINATE_SYSTEM_PRIM	NORMAL	UNIQUE	SYSTEM	COORD_SYS_ID
SYS_C00186535	NORMAL	UNIQUE	SYSTEM	COORD_SYS_NAME
SDO_COORD_SYS_COORD_SYS_TYPE	NORMAL	NONUNIQUE	SYSTEM	COORD_SYS_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
SDO_COORD_AXES		SDO_COORD_SYS	SDO_COORD_AXES COORD_SYS_ID
SDO_COORD_REF_SYS		SDO_COORD_SYS	SDO_COORD_REF_SYS COORD_SYS_ID

Columns

Name	Datatype	Length	Mandatory
COORD_SYS_ID	NUMBER	(10)	Yes
COORD_SYS_NAME	VARCHAR2	(254)	Yes
COORD_SYS_TYPE	VARCHAR2	(24)
DIMENSION	NUMBER	(5)
INFORMATION_SOURCE	VARCHAR2	(254)
DATA_SOURCE	VARCHAR2	(50)

Query Text

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


SELECT COORD_SYS_ID
,      COORD_SYS_NAME
,      COORD_SYS_TYPE
,      DIMENSION
,      INFORMATION_SOURCE
,      DATA_SOURCE
FROM MDSYS.SDO_COORD_SYS;

Dependencies

[top of page]

MDSYS.SDO_COORD_SYS does not reference any database object

MDSYS.SDO_COORD_SYS is referenced by following:

MDSYS: SDO_CS - show dependent code
PUBLIC: SDO_COORD_SYS