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.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

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.

update : 18-08-2017
ORA-22856

ORA-22856 - cannot add columns to object tables
ORA-22856 - cannot add columns to object tables

  • ora-01256 : error in locking database file string
  • ora-38484 : FUNCTION/PACKAGE/TYPE string does not exist
  • ora-23457 : invalid flavor ID string
  • ora-16177 : media recovery is not required
  • ora-38752 : file string does not exist
  • ora-24421 : OCISessionRelease cannot be used to release this session.
  • ora-24762 : server failed due to unspecified error
  • ora-00025 : failed to allocate string
  • ora-13347 : the coordinates defining an arc are not distinct
  • ora-01337 : log file has a different compatibility version
  • ora-01118 : cannot add any more database files: limit of string exceeded
  • ora-29346 : invalid tablespace list
  • ora-13123 : invalid name specified
  • ora-27191 : sbtinfo2 returned error
  • ora-24047 : invalid agent name string, agent name should be of the form NAME
  • ora-31214 : DBMS_LDAP: PL/SQL - Invalid LDAP mod type.
  • ora-32815 : message system link string is referenced by a foreign queue
  • ora-39771 : stream must be loaded before its handle is freed
  • ora-36630 : (XSDUNION00) An empty base dimension list was specified in the concat dimension definition.
  • ora-01274 : cannot add datafile 'string' - file could not be created
  • ora-02399 : exceeded maximum connect time, you are being logged off
  • ora-07485 : scg_get_inst: cannot open instance number lock.
  • ora-06810 : TLI Driver: could not set the IPX ethernet SAP at init
  • ora-29971 : Specified table name not found or does not have any registrations
  • ora-30510 : system triggers cannot be defined on the schema of SYS user
  • ora-01333 : failed to establish Logminer Dictionary
  • ora-36267 : (XSCGMDLAGG09) workspace object has no dimensions, so it cannot have a qualified data reference.
  • ora-28335 : referenced or referencing FK constraint column cannot be encrypted
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-25154 : column part of USING clause cannot have qualifier
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.