DBA Data[Home] [Help] [Dependency Information]

TABLE: CTXSYS.DR$OBJECT

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

Storage Details
Tablespace: TablespaceCTXD
PCT Free: 10
PCT Used: 40
Primary Key: DRC$OBJ_KEY
  1. ColumnOBJ_CLA_ID
  2. ColumnOBJ_ID
Unique Key: DRC$OBJ_NAME
  1. ColumnOBJ_NAME
Indexes
Index Type Uniqueness Tablespace Column
DRC$OBJ_KEY NORMAL UNIQUE TablespaceCTXD ColumnOBJ_CLA_ID
ColumnOBJ_ID
DRC$OBJ_NAME NORMAL UNIQUE TablespaceCTXD ColumnOBJ_NAME
Columns
Name Datatype Length Mandatory Comments
OBJ_CLA_ID NUMBER
Yes
OBJ_ID NUMBER
Yes
OBJ_NAME VARCHAR2 (30)
OBJ_DESC VARCHAR2 (80)
OBJ_SYSTEM CHAR (1)
Query Text

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


SELECT OBJ_CLA_ID
,      OBJ_ID
,      OBJ_NAME
,      OBJ_DESC
,      OBJ_SYSTEM
FROM CTXSYS.DR$OBJECT;

Dependencies

[top of page]

CTXSYS.DR$OBJECT does not reference any database object

CTXSYS.DR$OBJECT is referenced by following:

SchemaCTXSYS
ViewCTX_EXTRACT_POLICY_VALUES
ViewCTX_INDEX_OBJECTS
ViewCTX_INDEX_SUB_LEXER_VALUES
ViewCTX_INDEX_VALUES
ViewCTX_OBJECTS
ViewCTX_OBJECT_ATTRIBUTES
ViewCTX_OBJECT_ATTRIBUTE_LOV
ViewCTX_PREFERENCES
ViewCTX_SECTION_GROUPS
ViewCTX_STOPLISTS
ViewCTX_USER_EXTRACT_POLICY_VALUES
ViewCTX_USER_INDEX_OBJECTS
ViewCTX_USER_INDEX_SUB_LEXER_VALS
ViewCTX_USER_INDEX_VALUES
ViewCTX_USER_PREFERENCES
ViewCTX_USER_SECTION_GROUPS
ViewCTX_USER_STOPLISTS
Package BodyDRIEXP - show dependent code
Package BodyDRIIMP - show dependent code
Package BodyDRIMLX - show dependent code
Package BodyDRIPREF - show dependent code
Package BodyDRIXMD - show dependent code