Oninit
Talk to an expert →

Informix Error -32400: A Table_option has already been altered.

Cause and resolution

A Table_option has already been altered.

You can change only one table option (locking mode, extent size) for each ALTER TABLE session. If you have changed one table option and want to change another, you must first exit the ALTER TABLE Menu and build the modified table. Select the Exit option, then the Build-new-table option. Then select the Table_options option on the ALTER TABLE Menu, and make your next modification to the table.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32400 fires when DB-Access's ALTER TABLE Menu attempts a second table-option change in the same session — per the official guidance, only one table option (locking mode, extent size) can be changed per ALTER TABLE session.

  1. A second table-option change attempted in the same ALTER TABLE Menu session, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Exit the ALTER TABLE Menu and build the modified table via the Build-new-table option, per the official guidance, for the first change.
  2. Select Table_options on the ALTER TABLE Menu again for the next modification, per the official guidance — starting a fresh session per change.
Examples
N/A

No specific triggering statement is documented — this is a DB-Access interactive-menu restriction.

Diagnostic Checks
  1. Confirm only one table option is being changed per ALTER TABLE Menu session.
Related Errors / Related Topics
  • -32411 — "An Alter Table Option has already been altered." The same one-change- per-session restriction, worded for a specific already-altered option.

DB-Access's ALTER TABLE Menu only allows one table-option change per session — exit and build the table, then start a new session for the next change.