ORA-22857: cannot modify columns of object tables

Cause : An attempt was made to alter the object table by modifing existing columns. An object table cannot be altered to modify existing columns since it is based on an object type. The table definition must be in sync with the corresponding type.

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

Create a new type with the desired attribute types and use it to create an object table. The new object table will have the desired columns.

update : 20-08-2017
ORA-22857

ORA-22857 - cannot modify columns of object tables
ORA-22857 - cannot modify columns of object tables

  • ora-18010 : command missing mandatory CATEGORY keyword
  • ora-29813 : non-supported object type with associate statement
  • ora-01482 : unsupported character set
  • ora-25254 : time-out in LISTEN while waiting for a message
  • ora-13293 : cannot specify unit for geometry without a georeferenced SRID
  • ora-30438 : unable to access named pipe 'string'
  • ora-37128 : (XSCCOMP03) It is not possible to PARTITION over a base of a COMPRESSED COMPOSITE.
  • ora-01254 : cannot end online backup - file string in recovery manager backup
  • ora-07286 : sksagdi: cannot obtain device information.
  • ora-34656 : (MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax
  • ora-19764 : database id string does not match database id string in control file
  • ora-32518 : cannot wait for ORADEBUG command completion (waited number ms for process string); total wait time exceeds number ms
  • ora-01173 : data dictionary indicates missing data file from system tablespace
  • ora-00976 : LEVEL, PRIOR, or ROWNUM not allowed here
  • ora-09829 : pw_createPorts: server call pws_start_instance failed.
  • ora-09975 : kxfspini: Error Initializing SDI Process
  • ora-00091 : LARGE_POOL_SIZE must be at least string
  • ora-13147 : failed to generate MBR
  • ora-02362 : error closing file: string
  • ora-28184 : global user cannot have proxy permissions managed in the directory
  • ora-14030 : non-existent partitioning column in CREATE TABLE statement
  • ora-04941 : required operating system patch needs to be applied
  • ora-33005 : (XSAGDIMBREAK) Invalid breakout for dimension workspace object.
  • ora-00252 : log string of thread string is empty, cannot archive
  • ora-06596 : unsupported LOB operation in RPC call
  • ora-00217 : control file could not be resized for new record types
  • ora-08194 : Flashback Table operation is not allowed on materialized views
  • ora-12601 : TNS:information flags check failed
  • ora-27434 : cannot alter chain step job string.string.string
  • ora-28670 : mapping table cannot be dropped due to an existing bitmap index
  • 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.