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


TABLE: CTXSYS.DR$SECTION

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

Storage Details
Tablespace: TablespaceCTXD
PCT Free: 10
PCT Used: 40
Primary Key: DRC$SEC_KEY
  1. ColumnSEC_ID
Indexes
Index Type Uniqueness Tablespace Column
DRC$SEC_KEY NORMAL UNIQUE TablespaceCTXD ColumnSEC_ID
DRX$SEC_NAME NORMAL NONUNIQUE TablespaceCTXD ColumnSEC_NAME
ColumnSEC_SGP_ID
DRX$SEC_TAG NORMAL NONUNIQUE TablespaceCTXD ColumnSEC_TAG
ColumnSEC_SGP_ID
Columns
Name Datatype Length Mandatory Comments
SEC_ID NUMBER
Yes
SEC_TYPE NUMBER

SEC_NAME VARCHAR2 (30) Yes
SEC_SGP_ID NUMBER

SEC_TAG VARCHAR2 (256)
SEC_FID NUMBER

SEC_VISIBLE CHAR (1)
SEC_DATATYPE NUMBER

Query Text

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


SELECT SEC_ID
,      SEC_TYPE
,      SEC_NAME
,      SEC_SGP_ID
,      SEC_TAG
,      SEC_FID
,      SEC_VISIBLE
,      SEC_DATATYPE
FROM CTXSYS.DR$SECTION;

Dependencies

[top of page]

CTXSYS.DR$SECTION does not reference any database object

CTXSYS.DR$SECTION is referenced by following:

SchemaCTXSYS
ViewCTX_SECTIONS
ViewCTX_USER_SECTIONS
Package BodyDRISGP - show dependent code