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_ELLIPSOIDS

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: ELLIPSOID_PRIM

ELLIPSOID_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
ELLIPSOID_PRIM	NORMAL	UNIQUE	SYSTEM	ELLIPSOID_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
SDO_ELLIPSOIDS	SDO_UNITS_OF_MEASURE	SDO_ELLIPSOIDS UOM_ID
SDO_DATUMS	SDO_ELLIPSOIDS	SDO_DATUMS ELLIPSOID_ID
SDO_UNITS_OF_MEASURE	SDO_ELLIPSOIDS	SDO_UNITS_OF_MEASURE LEGACY_CODE

Columns

Name	Datatype	Length	Mandatory
ELLIPSOID_ID	NUMBER		Yes
ELLIPSOID_NAME	VARCHAR2	(80)	Yes
SEMI_MAJOR_AXIS	NUMBER
UOM_ID	NUMBER
INV_FLATTENING	NUMBER
SEMI_MINOR_AXIS	NUMBER
INFORMATION_SOURCE	VARCHAR2	(254)
DATA_SOURCE	VARCHAR2	(40)
IS_LEGACY	VARCHAR2	(5)	Yes
LEGACY_CODE	NUMBER

Query Text

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


SELECT ELLIPSOID_ID
,      ELLIPSOID_NAME
,      SEMI_MAJOR_AXIS
,      UOM_ID
,      INV_FLATTENING
,      SEMI_MINOR_AXIS
,      INFORMATION_SOURCE
,      DATA_SOURCE
,      IS_LEGACY
,      LEGACY_CODE
FROM MDSYS.SDO_ELLIPSOIDS;

Dependencies

[top of page]

MDSYS.SDO_ELLIPSOIDS does not reference any database object

MDSYS.SDO_ELLIPSOIDS is referenced by following:

MDSYS: SDO_CS - show dependent code; SDO_ELLIPSOIDS_OLD_FORMAT
PUBLIC: SDO_ELLIPSOIDS