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 : 25-06-2017
ORA-22856

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

  • ora-29347 : Tablespace name validation failed - failed to match tablespace 'string'
  • ora-37037 : (XSMLTDCL03) You cannot RENAME objects in analytic workspace string because it is attached in MULTI mode.
  • ora-39953 : the range value specified is beyond allowed range
  • ora-32766 : instr with negative offset: use varchar semantics on LOBs
  • ora-29914 : ODCIGETINTERFACES routine does not return required stream version
  • ora-27546 : Oracle compiled against IPC interface version string.string found version string.string
  • ora-00366 : log string of thread string, checksum error in the file header
  • ora-04006 : START WITH cannot be less than MINVALUE
  • ora-32338 : on commit refresh grab all the detailed tables
  • ora-39753 : unsupported use of subquery in PARTITIONED OUTER JOIN condition
  • ora-19672 : media management software returned invalid file status
  • ora-28357 : password required to open the wallet
  • ora-19958 : potential deadlock involving DIAG process
  • ora-31481 : change source string is not a HotLog change source
  • ora-19650 : Offline-range record recid string stamp string in file string has SCN string
  • ora-22617 : error while accessing the image handle collection
  • ora-19711 : cannot use reNormalizeAllFileNames while database is open
  • ora-32640 : FOR LIKE loops are not allowed for multi-byte character types
  • ora-01259 : unable to delete datafile string
  • ora-02295 : found more than one enable/disable clause for constraint
  • ora-01688 : unable to extend table string.string partition string by string in tablespace string
  • ora-07685 : sou2os: supervisor stack set error
  • ora-24814 : operation not allowed for temporary LOBs
  • ora-00309 : log belongs to wrong database
  • ora-27072 : File I/O error
  • ora-19160 : XP0003 - syntax error: invalid variable name string
  • ora-30940 : Cannot resolve prefix 'string' for QName node 'string'
  • ora-22346 : Type has cyclical dependency. Should use CASCADE option
  • ora-14152 : invalid number of partitions specified in PARTITIONS clause
  • ora-16407 : Standby database is in the future of the archive log
  • 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.