You are here: Home // Oracle 11g // ORA-22856: cannot add columns to object tables

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. See the solution below.

Error 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.

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: nagrobki nieruchomoƛci lublin biuro rachunkowe marki kasetony reklamowe Hearing Aids