U0000005: The length of the object name exceeds the upper limit allowed by GaussDB
Description
Database Type and Version
- Source database type and version: all types
- Target database type and version: all GaussDB versions
Syntax Example
If the name of an object to be migrated contains more than 63 characters, UGO retains the object name and reports this error message.
Object (such as table, column, and function) names of a GaussDB database must comply with identifier naming rules and contain a maximum of 63 characters. If the object name contains more than 63 characters, only the first 63 characters will be retained. For example, the following statement is successfully executed on the GaussDB database:
CREATE TABLE max_length_test_01_max_length_test_02_max_length_test_03_max_length_test_04_max_length_test_05_max_length_test_06_max_length_test_07(id INT);
However, the created table is named max_length_test_01_max_length_test_02_max_length_test_03_max_le, different from what was anticipated.
Suggestion
If the object name of the source database contains more than 63 characters, rename the object according to object naming rules of the GaussDB database before migration. For details about object naming rules, see GaussDB Developer Guide.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot