Whether the Selected Objects Exist in the Destination Database

Whether the selected objects exist in the destination database

Check whether the destination database objects meet the synchronization requirements.

Failure cause: The selected schema does not exist in the destination database.

Handling suggestion: Create the schema in the destination database. Statement for creating a schema:

CREATE SCHEMA schema_name;

Failure cause: Source database names are the same except for letter cases.

Handling suggestion: Change the table name or return to the object selection page and deselect the tables with the same name.

Statement for changing the table name in the Oracle database:

ALTER TABLE old_table_name RENAME TO new_table_name;

Failure cause: The selected table does not exist in the destination database or the table structure is inconsistent with that in the source database.

Handling suggestion: Create a table in the destination database and ensure that the table structure is the same as that in the source database. Statement for creating a table:

CREATE TABLE table_name (column_name data_type);

Failure cause: The destination table contains data, which may cause data conflict or inconsistency.

Handling suggestion: Run the following SQL statement to delete data from the table:

TRUNCATE TABLE table_name;

Failure cause: The source and destination databases cannot contain same materialized view names.

Handling suggestion: Data operations cannot be directly performed on materialized views. Select base tables for data synchronization.

Whether the selected objects exist in the destination database

Check whether the destination database objects meet the synchronization requirements.

Failure cause: The destination database table does not exist and cannot be synchronized.

Handling suggestion: If you do not synchronize the table structure, create the table to be synchronized in the destination database in advance. Statement for creating a table in the destination database:

CREATE TABLE table_name (column_name data_type);

Failure cause: Source database names are the same except for letter cases.

Handling suggestion: Change the table name or return to the object selection page and deselect the tables with the same name.

Statement for changing a table name in the DB2 for LUW database:

RENAME TABLE old_table_name to new_table_name;