10g Disabled Triggers And Primary Key Constraints In Database Dictionary upon install (Doc ID 456282.1)

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Oracle Database - Standard Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 19-Nov-2010***

Goal

Some dictionary objects(triggers and primary key constraints) are disabled in all newly created 10g databases, is this to be expected?

==>There are 15 DISABLED dictionary triggers as follows:
OWNER TRIGGER_NAME TRIGGER_TYPE STATUS
------ --------------------- --------------- -------
SYS NO_VM_DROP BEFORE EVENT DISABLED
SYS NO_VM_DROP_A AFTER EVENT DISABLED
SYS NO_VM_CREATE BEFORE EVENT DISABLED
SYS NO_VM_ALTER BEFORE EVENT DISABLED
SYS AURORA$SERVER$STARTUP AFTER EVENT DISABLED
SYS AURORA$SERVER$SHUTDOWN BEFORE EVENT DISABLED
SYS CDC_ALTER_CTABLE_BEFORE BEFORE EVENT DISABLED
SYS CDC_CREATE_CTABLE_AFTER AFTER EVENT DISABLED
SYS CDC_CREATE_CTABLE_BEFORE BEFORE EVENT DISABLED
SYS CDC_DROP_CTABLE_BEFORE BEFORE EVENT DISABLED
EXFSYS EXPFIL_RESTRICT_TYPEEVOLVE BEFORE EVENT DISABLED
EXFSYS EXPFIL_ALTEREXPTAB_MAINT AFTER EVENT DISABLED
EXFSYS EXPFIL_DROPOBJ_MAINT BEFORE EVENT DISABLED
EXFSYS EXPFIL_DROPUSR_MAINT AFTER EVENT DISABLED
EXFSYS RLMGR_TRUNCATE_MAINT BEFORE EVENT DISABLED

==>There are 23 DISABLED dictionary PK constraints as follows:
OWNER CONSTRAINT_NAME CONSTRAINT_TYPE STATUS
------ --------------------- --------------- -------
SYSTEM LOGMNR_INDCOMPART$_PK P DISABLED
SYSTEM LOGMNR_INDSUBPART$_PK P DISABLED
SYSTEM LOGMNR_INDPART$_PK P DISABLED
SYSTEM LOGMNR_LOBFRAG$_PK P DISABLED
SYSTEM LOGMNR_ICOL$_PK P DISABLED
SYSTEM LOGMNR_CCOL$_PK P DISABLED
SYSTEM LOGMNR_CDEF$_PK P DISABLED
SYSTEM LOGMNR_LOB$_PK P DISABLED
SYSTEM LOGMNR_ATTRIBUTE$_PK P DISABLED
SYSTEM LOGMNR_COLTYPE$_PK P DISABLED
SYSTEM LOGMNR_TYPE$_PK P DISABLED
SYSTEM LOGMNR_TABCOMPART$_PK P DISABLED
SYSTEM LOGMNR_TABSUBPART$_PK P DISABLED
SYSTEM LOGMNR_TABPART$_PK P DISABLED
SYSTEM LOGMNR_IND$_PK P DISABLED
SYSTEM LOGMNR_TS$_PK P DISABLED
SYSTEM LOGMNR_ATTRCOL$_PK P DISABLED
SYSTEM LOGMNR_COL$_PK P DISABLED
SYSTEM LOGMNR_TAB$_PK P DISABLED
SYSTEM LOGMNR_USER$_PK P DISABLED
SYSTEM LOGMNR_OBJ$_PK P DISABLED
SYSTEM LOGMNR_DICTIONARY$_PK P DISABLED
SYSTEM LOGMNR_DICTSTATE$_PK P DISABLED

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms