Whether the Destination Database User (Schema) and Table Exist

Whether the destination database user (schema) and table exist

To synchronize data from GaussDB to the Oracle database, you need to create the corresponding user (schema) and table in the destination database in advance.

Failure cause: The destination database user corresponding to the selected schema does not exist.

Handling suggestion: Create a user with the same source database schema name in the destination database. Statement for creating a user:

CREATE USER user_name IDENTIFIED BY password;

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;