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


TABLE: SYS.CON$

Object Details
Object Name: CON$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_CON1 NORMAL UNIQUE TablespaceSYSTEM ColumnOWNER#
ColumnNAME
I_CON2 NORMAL UNIQUE TablespaceSYSTEM ColumnCON#
Columns
Name Datatype Length Mandatory Comments
OWNER# NUMBER
Yes
NAME VARCHAR2 (128) Yes
CON# NUMBER
Yes
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 VARCHAR2 (1000)
SPARE5 VARCHAR2 (1000)
SPARE6 DATE

Query Text

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


SELECT OWNER#
,      NAME
,      CON#
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
FROM SYS.CON$;

Dependencies

[top of page]

SYS.CON$ does not reference any database object

SYS.CON$ is referenced by following:

SchemaAPPS
Package BodyETRM_PNAV - show dependent code
Package BodyETRM_RPT - show dependent code
SchemaCTXSYS
ProcedureDRI_MOVE_CTXSYS - show dependent code
SchemaSYS
ViewALL_CONS_COLUMNS
ViewALL_LOG_GROUPS
ViewALL_LOG_GROUP_COLUMNS
ViewALL_PART_TABLES
ViewDBA_CONS_COLUMNS
ViewDBA_LOG_GROUPS
ViewDBA_LOG_GROUP_COLUMNS
ViewDBA_PART_TABLES
Package BodyDBMSOBJG - show dependent code
Package BodyDBMS_DEFERGEN - show dependent code
Package BodyDBMS_LOGMNR_INTERNAL - show dependent code
Package BodyDBMS_REDEFINITION_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_CONF - show dependent code
Package BodyDBMS_SNAPSHOT - show dependent code
Package BodyDBMS_SNAPSHOT_UTL - show dependent code
ViewEXU10CCLO
ViewEXU11IND
ViewEXU7CCLO
ViewEXU7COLNN
ViewEXU7CON
ViewEXU7IND
ViewEXU7REF
ViewEXU7RIF
ViewEXU7VEW
ViewEXU7VEWU
ViewEXU81IND
ViewEXU8CCLO
ViewEXU8COLNN
ViewEXU8CON
ViewEXU8OID
ViewEXU8REF
ViewEXU8RIF
ViewEXU8VEW
ViewEXU8VEWU
ViewEXU8VINF
ViewEXU9CCLO
ViewEXU9IND
ViewIMP8CDT
ViewIMP8CON
ViewIMP9CON
ViewINT$INT$DBA_CONSTRAINTS
ViewKU$_CONSTRAINT0_VIEW
ViewKU$_CONSTRAINT1_VIEW
ViewKU$_CONSTRAINT2_VIEW
ViewKU$_CONSTRAINT_EXISTS_VIEW
ViewKU$_CONSTRAINT_VIEW
ViewKU$_FIND_HIDDEN_CONS_VIEW
ViewKU$_FIND_SGC_VIEW
ViewKU$_REF_CONSTRAINT_EXISTS_VIEW
ViewKU$_REF_CONSTRAINT_VIEW
ViewLOADER_CONSTRAINT_INFO
ViewTS_PITR_CHECK
ViewUNI_PLUGGABLE_SET_CHECK
ViewUSER_CONS_COLUMNS
ViewUSER_LOG_GROUPS
ViewUSER_LOG_GROUP_COLUMNS
ViewUSER_PART_TABLES
View_DBA_APPLY_TABLE_COLUMNS_H