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_AXES

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: COORD_AXIS_PRIM

COORD_SYS_ID
ORDER

Indexes

Index	Type	Uniqueness	Tablespace	Column
COORD_AXIS_PRIM	NORMAL	UNIQUE	SYSTEM	COORD_SYS_ID ORDER

Foreign Keys

Table	Foreign Table	Foreign Key Column
SDO_COORD_AXES	SDO_COORD_AXIS_NAMES	SDO_COORD_AXES COORD_AXIS_NAME_ID
SDO_COORD_AXES	SDO_COORD_SYS	SDO_COORD_AXES COORD_SYS_ID
SDO_COORD_AXES	SDO_UNITS_OF_MEASURE	SDO_COORD_AXES UOM_ID

Columns

Name	Datatype	Length	Mandatory
COORD_SYS_ID	NUMBER	(10)	Yes
COORD_AXIS_NAME_ID	NUMBER	(10)
COORD_AXIS_ORIENTATION	VARCHAR2	(24)
COORD_AXIS_ABBREVIATION	VARCHAR2	(24)
UOM_ID	NUMBER	(10)
ORDER	NUMBER	(5)	Yes

Query Text

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


SELECT COORD_SYS_ID
,      COORD_AXIS_NAME_ID
,      COORD_AXIS_ORIENTATION
,      COORD_AXIS_ABBREVIATION
,      UOM_ID
,      ORDER
FROM MDSYS.SDO_COORD_AXES;

Dependencies

[top of page]

MDSYS.SDO_COORD_AXES does not reference any database object

MDSYS.SDO_COORD_AXES is referenced by following:

MDSYS: SDO_CS - show dependent code
PUBLIC: SDO_COORD_AXES