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_THEMES_TABLE

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: UNIQUE_THEMES

SDO_OWNER
NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000235725C00006$$	LOB	UNIQUE	SYSTEM
UNIQUE_THEMES	NORMAL	UNIQUE	SYSTEM	SDO_OWNER NAME
SDO_THEMES_IDX	NORMAL	NONUNIQUE	SYSTEM	SDO_OWNER BASE_TABLE

Columns

Name	Datatype	Length	Mandatory
SDO_OWNER	VARCHAR2	(32)	Yes
NAME	VARCHAR2	(32)	Yes
DESCRIPTION	VARCHAR2	(4000)
BASE_TABLE	VARCHAR2	(64)	Yes
GEOMETRY_COLUMN	VARCHAR2	(2048)	Yes
STYLING_RULES	CLOB	(4000)	Yes

Query Text

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


SELECT SDO_OWNER
,      NAME
,      DESCRIPTION
,      BASE_TABLE
,      GEOMETRY_COLUMN
,      STYLING_RULES
FROM MDSYS.SDO_THEMES_TABLE;

Dependencies

[top of page]

MDSYS.SDO_THEMES_TABLE does not reference any database object

MDSYS.SDO_THEMES_TABLE is referenced by following:

MDSYS: ALL_SDO_THEMES; DBA_SDO_THEMES; USER_SDO_THEMES