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: CTXSYS.DR$OBJECT_ATTRIBUTE

Object Details

Object Name:	DR$OBJECT_ATTRIBUTE
Object Type:	TABLE
Owner:	CTXSYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	CTXD
PCT Free:	10
PCT Used:	40

Primary Key: DRC$OAT_KEY

OAT_ID

Unique Key: DRC$OAT_NAME

OAT_CLA_ID
OAT_OBJ_ID
OAT_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
DRC$OAT_KEY	NORMAL	UNIQUE	CTXD	OAT_ID
DRC$OAT_NAME	NORMAL	UNIQUE	CTXD	OAT_CLA_ID OAT_OBJ_ID OAT_NAME

Columns

Name	Datatype	Length	Mandatory
OAT_ID	NUMBER		Yes
OAT_CLA_ID	NUMBER
OAT_OBJ_ID	NUMBER
OAT_ATT_ID	NUMBER
OAT_NAME	VARCHAR2	(30)
OAT_DESC	VARCHAR2	(80)
OAT_REQUIRED	CHAR	(1)
OAT_SYSTEM	CHAR	(1)
OAT_STATIC	CHAR	(1)
OAT_DATATYPE	CHAR	(1)
OAT_DEFAULT	VARCHAR2	(500)
OAT_VAL_MIN	NUMBER
OAT_VAL_MAX	NUMBER
OAT_LOV	CHAR	(1)

Query Text

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


SELECT OAT_ID
,      OAT_CLA_ID
,      OAT_OBJ_ID
,      OAT_ATT_ID
,      OAT_NAME
,      OAT_DESC
,      OAT_REQUIRED
,      OAT_SYSTEM
,      OAT_STATIC
,      OAT_DATATYPE
,      OAT_DEFAULT
,      OAT_VAL_MIN
,      OAT_VAL_MAX
,      OAT_LOV
FROM CTXSYS.DR$OBJECT_ATTRIBUTE;

Dependencies

[top of page]

CTXSYS.DR$OBJECT_ATTRIBUTE does not reference any database object

CTXSYS.DR$OBJECT_ATTRIBUTE is referenced by following:

CTXSYS: CTX_EXTRACT_POLICY_VALUES; CTX_INDEX_SUB_LEXER_VALUES; CTX_INDEX_VALUES; CTX_OBJECT_ATTRIBUTES; CTX_OBJECT_ATTRIBUTE_LOV; CTX_PREFERENCE_VALUES; CTX_USER_EXTRACT_POLICY_VALUES; CTX_USER_INDEX_SUB_LEXER_VALS; CTX_USER_INDEX_VALUES; CTX_USER_PREFERENCE_VALUES; DRIEXP - show dependent code; DRIIMP - show dependent code; DRIIXS - show dependent code; DRIMLX - show dependent code; DRIPREF - show dependent code; DRISGP - show dependent code; DRISPL - show dependent code; DRIVAL - show dependent code; DRIXMD - show dependent code