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 : 28-04-2017
ORA-22857

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

  • ora-19003 : Missing XML root element name
  • ora-30372 : fine grain access policy conflicts with materialized view
  • ora-01912 : ROW keyword expected
  • ora-29850 : invalid option for creation of domain indexes
  • ora-26021 : index string.string partition string loaded successfully with string keys
  • ora-12672 : Database logon failure
  • ora-09282 : sllfrb: error reading records
  • ora-12711 : this CREATE CONTROLFILE character set is not allowed
  • ora-07277 : spdde: illegal pid passed as argument.
  • ora-29664 : Unable to generate the helper class for the defined type
  • ora-14512 : cannot perform operation on a clustered object
  • ora-25337 : Cannot propagate in queue-to-queue mode to a database with version lower than 10.2
  • ora-09261 : spdcr: error creating detached (background) process
  • ora-10842 : Event for OCI Tracing and Statistics Info
  • ora-14638 : cannot MERGE subpartitions in different Range Composite partitions
  • ora-36923 : (XSVPMVTOPART04) workspace object is not a LIST or RANGE PARTITION TEMPLATE.
  • ora-06743 : TLI Driver: cannot alloc t_bind
  • ora-09834 : snyGetPortSet: failed to collect info on a port.
  • ora-21615 : an OTS (named or simple) instance failed
  • ora-19710 : unsupported character set string
  • ora-06128 : NETTCP: unable to create mailbox
  • ora-24075 : cannot specify agent with NULL address and non-NULL protocol
  • ora-13438 : GeoRaster metadata pyramid type error
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-12842 : Cursor invalidated during parallel execution
  • ora-38713 : Flashback Database logging is already turned on.
  • ora-19811 : cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
  • ora-33449 : (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.
  • ora-14099 : all rows in table do not qualify for specified partition
  • ora-38752 : file string does not exist
  • 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.