[Home] [Help]
[Dependency Information]
TABLE: SYS.CDEF$
Object Details
Object Name: | CDEF$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 0 |
PCT Used: | 0 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_CDEF1
|
NORMAL
|
UNIQUE
|
SYSTEM
|
CON#
|
I_CDEF2
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
OBJ#
|
I_CDEF3
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
ROBJ#
|
I_CDEF4
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
ENABLED
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
CON# |
NUMBER |
|
Yes |
|
OBJ# |
NUMBER |
|
Yes |
|
COLS |
NUMBER |
|
|
|
TYPE# |
NUMBER |
|
Yes |
|
ROBJ# |
NUMBER |
|
|
|
RCON# |
NUMBER |
|
|
|
RRULES |
VARCHAR2 |
(3) |
|
|
MATCH# |
NUMBER |
|
|
|
REFACT |
NUMBER |
|
|
|
ENABLED |
NUMBER |
|
|
|
CONDLENGTH |
NUMBER |
|
|
|
CONDITION |
LONG |
(0) |
|
|
INTCOLS |
NUMBER |
|
|
|
MTIME |
DATE |
|
|
|
DEFER |
NUMBER |
|
|
|
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 CON#
, OBJ#
, COLS
, TYPE#
, ROBJ#
, RCON#
, RRULES
, MATCH#
, REFACT
, ENABLED
, CONDLENGTH
, CONDITION
, INTCOLS
, MTIME
, DEFER
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
FROM SYS.CDEF$;
Dependencies
[top of page]
SYS.CDEF$ does not reference any database object
SYS.CDEF$ is referenced by following:
-
APPS
-
ETRM_PNAV
- show dependent code
-
CTXSYS
-
DRI_MOVE_CTXSYS
- show dependent code
-
SYS
-
ALL_CLUSTER_HASH_EXPRESSIONS
-
ALL_CONS_COLUMNS
-
ALL_LOG_GROUPS
-
ALL_LOG_GROUP_COLUMNS
-
ALL_PART_TABLES
-
DBA_CAPTURE_PREPARED_TABLES
-
DBA_CLUSTER_HASH_EXPRESSIONS
-
DBA_CONS_COLUMNS
-
DBA_IAS_CONSTRAINT_EXP
-
DBA_LOGSTDBY_EDS_SUPPORTED
-
DBA_LOGSTDBY_NOT_UNIQUE
-
DBA_LOG_GROUPS
-
DBA_LOG_GROUP_COLUMNS
-
DBA_PART_TABLES
-
DBMSOBJG
- show dependent code
-
DBMS_DEFERGEN
- show dependent code
-
DBMS_INTERNAL_LOGSTDBY
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_METADATA_UTIL
- show dependent code
-
DBMS_REDEFINITION_INTERNAL
- show dependent code
-
DBMS_SNAPSHOT
- show dependent code
-
DBMS_SNAPSHOT_UTL
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
EXU10CCLO
-
EXU11IND
-
EXU7CCLO
-
EXU7CLU
-
EXU7COLNN
-
EXU7CON
-
EXU7REF
-
EXU7RIF
-
EXU7VEW
-
EXU7VEWU
-
EXU81IND
-
EXU8CCLO
-
EXU8CLU
-
EXU8COLNN
-
EXU8CON
-
EXU8OID
-
EXU8REF
-
EXU8RFS
-
EXU8RIF
-
EXU8VEW
-
EXU8VEWU
-
EXU8VINF
-
EXU9CCLO
-
EXU9IND
-
IMP8CDT
-
IMP8CON
-
IMP9CON
-
INT$DBA_JSON_COLUMNS
-
INT$INT$DBA_CONSTRAINTS
-
KU$_ALL_INDEX_VIEW
-
KU$_CLUSTER_VIEW
-
KU$_CONSTRAINT0_VIEW
-
KU$_CONSTRAINT1_VIEW
-
KU$_CONSTRAINT2_VIEW
-
KU$_CONSTRAINT_EXISTS_VIEW
-
KU$_CONSTRAINT_VIEW
-
KU$_FIND_HIDDEN_CONS_VIEW
-
KU$_FIND_SGC_VIEW
-
KU$_PKREF_CONSTRAINT_VIEW
-
KU$_REF_CONSTRAINT_EXISTS_VIEW
-
KU$_REF_CONSTRAINT_VIEW
-
KU$_REF_PAR_LEVEL_VIEW
-
KU$_SIMPLE_PKREF_COL_VIEW
-
KU$_VIEW_VIEW
-
LOADER_CONSTRAINT_INFO
-
LOGMNR$ALWAYSSUPLOG_PROC
- show dependent code
-
LOGSTDBY_RU_UNSUPPORT_TAB_12_1
-
LOGSTDBY_SUPPORT_TAB_12_1
-
LOGSTDBY_UNSUPPORT_TAB_12_1
-
REPCAT$_CDEF
-
STRADDLING_RS_OBJECTS
-
STRADDLING_TS_OBJECTS
-
TS_PITR_INFO
-
TS_PLUG_INFO
-
USER_CLUSTER_HASH_EXPRESSIONS
-
USER_CONS_COLUMNS
-
USER_LOG_GROUPS
-
USER_LOG_GROUP_COLUMNS
-
USER_PART_TABLES
-
_DBA_APPLY_TABLE_COLUMNS_H
-
_DBA_XSTREAM_OUT_ADT_PK_TABLES