Informix Error -23860: This operation is not allowed on a duplicated table (<tabname>). </tabname>
Cause and resolution
This operation is not allowed on a duplicated table (<tabname>). </tabname>
The specified table has been duplicated with the CREATE DUPLICATE statement. The attempted operation is not allowed on a duplicated table.
To perform the operation, first issue a DROP DUPLICATE statement for <tabname>. After you perform the operation against the nonduplicated table, consider whether you need to issue another CREATE DUPLICATE command to duplicate the table again. </tabname>
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23860 fires when an operation not allowed on a duplicated table is attempted — per the
official guidance, the table was duplicated via CREATE DUPLICATE.
- An operation unsupported on a table duplicated via
CREATE DUPLICATE, per the official guidance — the direct, only cause.
Solutions / Resolution
- Issue
DROP DUPLICATEfor the table first, per the official guidance. - Perform the operation against the nondupicated table, per the official guidance.
- Consider whether
CREATE DUPLICATEneeds to be reissued afterward, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an unsupported operation on a duplicated table.
Diagnostic Checks
- Check whether the target table is currently duplicated, and issue
DROP DUPLICATEbefore the operation if so.
Related Errors / Related Topics
- -23858 — "This operation is not allowed on a temporary table (
)." The same class of table-kind restriction, for temporary tables rather than duplicated tables. - -23859 — "This operation is not allowed on a violations/diagnostics table
(
)." The same class of table-kind restriction, for violations/diagnostics tables rather than duplicated tables.
The operation isn't allowed on a duplicated table — issue DROP DUPLICATE first.