Help Center> Data Replication Service> Troubleshooting> Solutions to Failed Check Items> Database Parameters> Whether Foreign Keys Are Disabled or Tables to Be Synchronized Have Foreign Keys in the Destination Database
Updated on 2023-04-17 GMT+08:00
View PDF

Whether Foreign Keys Are Disabled or Tables to Be Synchronized Have Foreign Keys in the Destination Database

Oracle -> GaussDB Synchronization

Table 1 Checking whether foreign keys are disabled or tables to be synchronized have foreign keys in the destination database

Check Item

Whether foreign keys are disabled or tables to be synchronized have foreign keys in the destination database

Description

Check whether foreign keys are disabled or tables to be synchronized have foreign keys in the destination database.

Failure Cause and Handling Suggestion

Failure cause: Tables to be synchronized have foreign keys in the destination database and cannot be synchronized.

Handling suggestion: Delete the foreign key, disable the trigger, or change the value of session_replication_role to replica.

Parent topic: Database Parameters