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_GEOR_SYSDATA_TABLE

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: UNIQUE_GEORASTERS

SDO_OWNER
RDT_TABLE_NAME
RASTER_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000386286C00007$$	LOB	UNIQUE	SYSTEM
UNIQUE_GEORASTERS	NORMAL	UNIQUE	SYSTEM	SDO_OWNER RDT_TABLE_NAME RASTER_ID
SDO_GEOR_IDX	NORMAL	NONUNIQUE	SYSTEM	SDO_OWNER GEORASTER_TABLE_NAME
SDO_GEOR_IDX1	NORMAL	NONUNIQUE	SYSAUX	RDT_TABLE_NAME RASTER_ID

Columns

Name	Datatype	Length	Mandatory
SDO_OWNER	VARCHAR2	(32)	Yes
GEORASTER_TABLE_NAME	VARCHAR2	(32)	Yes
GEORASTER_COLUMN_NAME	VARCHAR2	(1024)	Yes
GEOR_METADATA_COLUMN_NAME	VARCHAR2	(1024)
RDT_TABLE_NAME	VARCHAR2	(32)	Yes
RASTER_ID	NUMBER		Yes
OTHER_TABLE_NAMES	SDO_STRING_ARRAY	(3748)

Query Text

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


SELECT SDO_OWNER
,      GEORASTER_TABLE_NAME
,      GEORASTER_COLUMN_NAME
,      GEOR_METADATA_COLUMN_NAME
,      RDT_TABLE_NAME
,      RASTER_ID
,      OTHER_TABLE_NAMES
FROM MDSYS.SDO_GEOR_SYSDATA_TABLE;

Dependencies

[top of page]

MDSYS.SDO_GEOR_SYSDATA_TABLE references the following:

MDSYS: SDO_STRING_ARRAY
SYS: STANDARD - show dependent code

MDSYS.SDO_GEOR_SYSDATA_TABLE is referenced by following:

MDSYS: ALL_SDO_GEOR_SYSDATA