My Oracle Support Banner

Replication Pre-Import: Trying To Disable Constraint (Doc ID 111228.1)

Last updated on JULY 31, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

During a full or fromuser / touser import using a full database export, the
following entries are logged to the alert.log:

Replication pre-import:
trying to disable constraint REPCAT$_TEMPLATE_OBJECTS_FK1
for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"
Replication pre-import:
constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for
"SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" is disabled successfully
...
Replication after-import:
trying to enable constraint REPCAT$_TEMPLATE_OBJECTS_FK1
for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"
Replication after-import:
constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for
"SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" is enabled successfully

These messages appear for all constraints related to replication catalog
objects (SYSTEM.REPCAT$_%).

The import terminates successfully, but why are these messages being logged to
the alert.log ?

Changes

{CHANGE}

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.