Whether the Destination Database User (Schema) and Table Exist
GaussDB -> Oracle Synchronization
Check Item |
Whether the destination database user (schema) and table exist |
---|---|
Description |
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 and Handling Suggestion |
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; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.