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$SECTION_GROUP

Object Details

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

Storage Details

Tablespace:	CTXD
PCT Free:	10
PCT Used:	40

Primary Key: DRC$SGP_KEY

SGP_ID

Unique Key: DRC$SGP_UNIQE

SGP_NAME
SGP_OWNER#

Indexes

Index	Type	Uniqueness	Tablespace	Column
DRC$SGP_KEY	NORMAL	UNIQUE	CTXD	SGP_ID
DRC$SGP_UNIQE	NORMAL	UNIQUE	CTXD	SGP_NAME SGP_OWNER#

Columns

Name	Datatype	Length	Mandatory
SGP_ID	NUMBER		Yes
SGP_OWNER#	NUMBER		Yes
SGP_NAME	VARCHAR2	(30)	Yes
SGP_OBJ_ID	NUMBER

Query Text

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


SELECT SGP_ID
,      SGP_OWNER#
,      SGP_NAME
,      SGP_OBJ_ID
FROM CTXSYS.DR$SECTION_GROUP;

Dependencies

[top of page]

CTXSYS.DR$SECTION_GROUP does not reference any database object

CTXSYS.DR$SECTION_GROUP is referenced by following:

CTXSYS: CTX_ADM - show dependent code; CTX_SECTIONS; CTX_SECTION_GROUPS; CTX_USER_SECTIONS; CTX_USER_SECTION_GROUPS; DRISGP - show dependent code