Informix Error -24145: Only permanent(base) tables can be moved.
Cause and resolution
Only permanent(base) tables can be moved.
Only user-created permanent tables can be moved across databases. The following table types cannot be moved: * TEMP and SCRATCH tables * System catalog tables * Active violation tables * Views
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-24145 fires when MOVE TABLE targets something other than a user-created permanent
table — per the official guidance, TEMP/SCRATCH tables, system catalog tables, active
violation tables, and views can't be moved.
MOVE TABLEtargeting aTEMP/SCRATCHtable, system catalog table, active violation table, or view, per the official guidance — the direct, only cause.
Solutions / Resolution
- Only use
MOVE TABLEon a user-created permanent (base) table, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond targeting a non-permanent table type.
Diagnostic Checks
- Check the target's table type, and confirm it's a user-created permanent (base)
table before using
MOVE TABLE.
Related Errors / Related Topics
- -24146 — "Username and rolename have conflicting permissions." A related
MOVE TABLEerror, on permission conflicts rather than table type. - -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. - -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 non-permanent table (temp/scratch, catalog, violation table, or
view) — only user-created permanent tables can be moved.