In this blog post, let’s learn about the error message “1757 GIVE TABLE-or-SCHEMA operation cannot be performed because object object-name has incompatible RI constraints for this operation.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1757 GIVE TABLE-or-SCHEMA operation cannot be performed because object object-name has incompatible RI constraints for this operation.
Reason for the Error
An attempt was made to perform one of the following operations:
A GIVE TABLE operation on a table that had referential integrity constraints with other table(s).
A GIVE SCHEMA operation on a schema that had one or more tables with referential integrity constraints. The referential integrity constraints were on table(s) in different schemas.
Solution
If the following conditions are met, perform the GIVE SCHEMA CASCADE operation to change the ownership of the table with referential integrity constraints:
Ownership of all the objects in the schema must be changed.
The table has referential integrity constraints with other table(s) in the same schema.
There are no tables having referential integrity constraints with tables in other schema(s)
