Tuesday, September 1, 2009

ORA-22856: Cannot add columns to object tables

If you get the error ORA-22856: Cannot add columns to object tables when trying to add columns to a table in Oracle9i, you propably have hit a bug.

The bug makes it impossible to add columns to a table in compressed state.
The solution is to alter the table to nocompress and rebuild it with the ALTER TABLE MOVE-statement before adding the columns.

No comments:

Post a Comment