[Home] [Help] [Dependency Information]

TABLE: MDSYS.SDO_DATUMS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: DATUM_PRIM

1. DATUM_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
DATUM_PRIM	NORMAL	UNIQUE	SYSTEM	DATUM_ID
SDO_DATUMS_DATUM_TYPE	NORMAL	NONUNIQUE	SYSTEM	DATUM_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
SDO_DATUMS		SDO_DATUMS	SDO_DATUMS LEGACY_CODE
SDO_DATUMS		SDO_ELLIPSOIDS	SDO_DATUMS ELLIPSOID_ID
SDO_DATUMS		SDO_PRIME_MERIDIANS	SDO_DATUMS PRIME_MERIDIAN_ID
SDO_COORD_REF_SYS		SDO_DATUMS	SDO_COORD_REF_SYS DATUM_ID
SDO_DATUMS		SDO_DATUMS	SDO_DATUMS LEGACY_CODE

Columns

Query Text

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

SELECT DATUM_ID
,      DATUM_NAME
,      DATUM_TYPE
,      ELLIPSOID_ID
,      PRIME_MERIDIAN_ID
,      INFORMATION_SOURCE
,      DATA_SOURCE
,      SHIFT_X
,      SHIFT_Y
,      SHIFT_Z
,      ROTATE_X
,      ROTATE_Y
,      ROTATE_Z
,      SCALE_ADJUST
,      IS_LEGACY
,      LEGACY_CODE
FROM MDSYS.SDO_DATUMS;

Dependencies

[top of page]

MDSYS.SDO_DATUMS does not reference any database object

MDSYS.SDO_DATUMS is referenced by following:

MDSYS

SDO_CS - show dependent code

SDO_DATUMS_OLD_FORMAT

SDO_DATUM_ENGINEERING

SDO_DATUM_GEODETIC

SDO_DATUM_VERTICAL

PUBLIC

SDO_DATUMS