Whether the Selected Objects Exist in the Destination Database

During a data synchronization with Oracle serving as the source database, DRS checks the consistency of destination database objects.

Object names will be converted to lowercase letters after being synchronized to the destination database. To avoid synchronization failures, ensure that the selected source database tables do not contain columns with the same name but different letter cases.
The selected table does not exist in the destination database or the table structure is inconsistent with that in the source database.
The constraints on the destination database are inconsistent with those on the source database. The synchronization may fail due to inconsistent constraints.

Delete columns with the same name but different letter cases from the source database tables, or change the names of columns with the same name but different letter cases in the source database tables.
If the selected table does not exist in the destination database, create the 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);
```
If the table structure is inconsistent with that in the source database, create missing columns in the destination database table, or convert the names of columns with the same name but different letter cases in the destination database table to lowercase letters, or delete redundant columns from the source database table.
Ensure that the constraints on the destination database are consistent with those on the source database, or confirm that inconsistent constraints do not adversely affect data migration.

Parent topic: Database Parameters