Whether the Table Structures (Including Primary Key Indexes and the Number of Columns) of the Source Oracle Database and Destination Database Middleware Are Aligned

Whether the table structures (including primary key indexes and the number of columns) of the source Oracle database and destination database middleware are aligned

Check whether the table structures (including primary key indexes and the number of columns) of the source Oracle database and destination DDM database are aligned.

Failure cause: The redundant columns (columns that do not exist in the source database) of the destination database cannot contain not-null constraints. The not-null constraints will cause the migration to fail.

Handling suggestion:

1. Check the not-null constraints on the redundant columns in the destination database.

   DESC [table_name];

2. Modify the non-null constraint on the redundant columns.

   Alter Table table_name Modify column_name NULL;

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:

ALTER TABLE old_table_name RENAME TO new_table_name;