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.OLS_DIR_CATEGORY_TYPES

Object Details

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

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: SYS_C00246972

CATEGORY_TYPE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00246972	NORMAL	UNIQUE	SYSAUX	CATEGORY_TYPE_ID
SYS_IL0000635032C00004$$	LOB	UNIQUE	SYSAUX

Foreign Keys

Table		Foreign Table	Foreign Key Column
OLS_DIR_CATEGORIES		OLS_DIR_CATEGORY_TYPES	OLS_DIR_CATEGORIES CATEGORY_TYPE_ID

Columns

Name	Datatype	Length	Mandatory
CATEGORY_TYPE_ID	NUMBER		Yes
CATEGORY_TYPE_NAME	VARCHAR2	(128)	Yes
PARAMETERS	XMLTYPE	(2000)

Query Text

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


SELECT CATEGORY_TYPE_ID
,      CATEGORY_TYPE_NAME
,      PARAMETERS
FROM MDSYS.OLS_DIR_CATEGORY_TYPES;

Dependencies

[top of page]

MDSYS.OLS_DIR_CATEGORY_TYPES references the following:

PUBLIC: XMLTYPE
SYS: STANDARD - show dependent code; XMLTYPE

MDSYS.OLS_DIR_CATEGORY_TYPES is not referenced by any database object