Informix Error -24148: Cannot move a table from the sysmaster and sysutils databases.
Cause and resolution
Cannot move a table from the sysmaster and sysutils databases.
You cannot move a table from either 'sysmaster' or 'sysutils' system databases.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-24148 fires when MOVE TABLE targets a table in the sysmaster or sysutils system
database — per the official guidance, tables in those databases can't be moved.
MOVE TABLEtargeting a table insysmasterorsysutils, per the official guidance — the direct, only cause.
Solutions / Resolution
- Don't use
MOVE TABLEonsysmaster/sysutilstables, per the official guidance — these system databases don't support the operation.
Examples
N/A
No specific triggering statement is documented beyond targeting a sysmaster/sysutils
table.
Diagnostic Checks
- Check whether the source table lives in
sysmasterorsysutils, and avoidMOVE TABLEfor it.
Related Errors / Related Topics
- -24145 — "Only permanent(base) tables can be moved." A related
MOVE TABLEerror, on non-permanent table types. - -24146 — "Username and rolename have conflicting permissions." A related
MOVE TABLEerror, on permission conflicts. - -24147 — "Source and destination database must be different." A related
MOVE TABLEerror, on same-database moves. - -24149 — "Owner name conflicts with role name in the destination database." A
related
MOVE TABLEerror, on owner/role-name conflicts. - -24150 — "Only users with DBA privileges can move the table." A related
MOVE TABLEerror, on privilege requirements.
MOVE TABLE targeted a sysmaster/sysutils table, which can't be moved.