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_CATEGORIZATIONS

Object Details

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

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: OLSPK1

BUSINESS_ID
CATEGORY_ID
CATEGORY_TYPE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OLSPK1	NORMAL	UNIQUE	SYSAUX	BUSINESS_ID CATEGORY_ID CATEGORY_TYPE_ID
SYS_IL0000635048C00007$$	LOB	UNIQUE	SYSAUX

Foreign Keys

Table		Foreign Table	Foreign Key Column
OLS_DIR_CATEGORIZATIONS		OLS_DIR_CATEGORIES	OLS_DIR_CATEGORIZATIONS CATEGORY_ID OLS_DIR_CATEGORIZATIONS CATEGORY_TYPE_ID

Columns

Name	Datatype	Length	Mandatory
BUSINESS_ID	NUMBER		Yes
CATEGORY_ID	VARCHAR2	(32)	Yes
CATEGORY_TYPE_ID	NUMBER		Yes
CATEGORIZATION_TYPE	VARCHAR2	(8)
USER_SPECIFIC_CATEG	VARCHAR2	(32)
PARAMETERS	XMLTYPE	(2000)

Query Text

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


SELECT BUSINESS_ID
,      CATEGORY_ID
,      CATEGORY_TYPE_ID
,      CATEGORIZATION_TYPE
,      USER_SPECIFIC_CATEG
,      PARAMETERS
FROM MDSYS.OLS_DIR_CATEGORIZATIONS;

Dependencies

[top of page]

MDSYS.OLS_DIR_CATEGORIZATIONS references the following:

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

MDSYS.OLS_DIR_CATEGORIZATIONS is referenced by following:

MDSYS: SDO_OLS_DIRECTORY - show dependent code