Informix Error -24149: Owner name conflicts with role name in the destination database.
Cause and resolution
Owner name conflicts with role name in the destination database.
During execution of the MOVE TABLE command, a conflict occurred between the target owner name and the existing role name in the destination database.
To correct this error: * Drop the conflicting role from the destination database. * Use the RENAME option with the MOVE TABLE command to specify a different target owner name, as in the following example: - MOVE TABLE 'o1'.t1 TO DATABASE destdb RENAME '02'.t1;
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-24149 fires during MOVE TABLE when the target owner name conflicts with an existing role
name in the destination database — per the official guidance.
- A
MOVE TABLEtarget owner name matching an existing role name in the destination database, per the official guidance — the direct, only cause.
Solutions / Resolution
- Drop the conflicting role from the destination database, per the official guidance, or
- Use the
RENAMEoption to specify a different target owner name, per the official guidance, e.g.MOVE TABLE 'o1'.t1 TO DATABASE destdb RENAME 'o2'.t1;.
Examples
Renaming to avoid an owner/role conflict
MOVE TABLE 'o1'.t1 TO DATABASE destdb RENAME 'o2'.t1;
Diagnostic Checks
- Check the destination database's roles for a name matching the intended target
owner, and drop the role or rename the owner via
RENAME.
Related Errors / Related Topics
- -24145 — "Only permanent(base) tables can be moved." A related
MOVE TABLEerror, on table type rather than owner/role conflicts. - -24146 — "Username and rolename have conflicting permissions." A related
MOVE TABLEpermission conflict, between the source database's role/username assignments rather than the destination owner name. - -24147 — "Source and destination database must be different." A related
MOVE TABLEerror, on same-database moves. - -24148 — "Cannot move a table from the sysmaster and sysutils databases." A related
MOVE TABLEerror, on system-database restrictions. - -24150 — "Only users with DBA privileges can move the table." A related
MOVE TABLEerror, on privilege requirements.
MOVE TABLE's target owner name conflicted with an existing role name in the destination
database — drop the role or RENAME the target owner.