The following is the ORA-22856 error message, you can learn the cause and solution of the Oracle database error.


ORA-22856 cannot add columns to object tables

Cause: An attempt was made to add columns to an object table. Object tables cannot be altered to add columns since its definition is based on an object type.

Solution: Create a new type with additional attributes, and use the new type to create an object table. The new object table will have the desired columns.

Case:

Please wait for the update…