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_3DTHEMES_TABLE

Object Details

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

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: UNIQUE_3DTHEMES

SDO_OWNER
NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000617616C00008$$	LOB	UNIQUE	SYSAUX
UNIQUE_3DTHEMES	NORMAL	UNIQUE	SYSAUX	SDO_OWNER NAME
SDO_3DTHEMES_IDX	NORMAL	NONUNIQUE	SYSAUX	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
THEME_COLUMN	VARCHAR2	(2048)	Yes
STYLE_COLUMN	VARCHAR2	(32)	Yes
THEME_TYPE	VARCHAR2	(32)
DEFINITION	CLOB	(4000)	Yes

Query Text

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


SELECT SDO_OWNER
,      NAME
,      DESCRIPTION
,      BASE_TABLE
,      THEME_COLUMN
,      STYLE_COLUMN
,      THEME_TYPE
,      DEFINITION
FROM MDSYS.SDO_3DTHEMES_TABLE;

Dependencies

[top of page]

MDSYS.SDO_3DTHEMES_TABLE does not reference any database object

MDSYS.SDO_3DTHEMES_TABLE is referenced by following:

MDSYS: ALL_SDO_3DTHEMES; USER_SDO_3DTHEMES