ORA-22859: invalid modification of columns

Cause : An attepmt was mdae to moidfy an ojbect, RE,F VARRAY ,nested atble, orL OB colunm type.

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

Create anew colmun of th edesiredt ype andc opy thec urrent oclumn daat to then ew typeu sing th eappropraite typec onstrucotr.

update : 24-06-2017

ORA-22859 - invalid modification of columns
ORA-22859 - invalid modification of columns

  • ora-06956 : Failed to get local host name
  • ora-12623 : TNS:operation is illegal in this state
  • ora-01585 : error identifying backup file string
  • ora-32314 : REFRESH FAST of "string"."string" unsupported after deletes/updates
  • ora-01209 : data file is from before the last RESETLOGS
  • ora-00976 : LEVEL, PRIOR, or ROWNUM not allowed here
  • ora-00085 : current call does not exist
  • ora-14292 : Partitioning type of table must match subpartitioning type of composite partition
  • ora-08208 : ora_addr: cannot read from address file
  • ora-30358 : summary and materialized view are not in same schema
  • ora-22980 : must specify a set of attributes for the WITH OBJECT OID clause
  • ora-07585 : spdcr: $PARSE failure
  • ora-16656 : higher DRC UID sequence number detected
  • ora-16502 : the Data Guard broker operation succeeded with warnings
  • ora-01494 : invalid SIZE specified
  • ora-00036 : maximum number of recursive SQL levels (string) exceeded
  • ora-26059 : Data is too large for column string
  • ora-04076 : invalid NEW or OLD specification
  • ora-29554 : unhandled Java out of memory condition
  • ora-12925 : tablespace string is not in force logging mode
  • ora-16791 : unable to check the existence of the standby redo logs
  • ora-24128 : partition name specified for a non-partitioned object
  • ora-00286 : no members available, or no member contains valid data
  • ora-12493 : invalid MLS binary label
  • ora-32828 : Messaging Gateway agent must be running
  • ora-16953 : Type of SQL statement not supported.
  • ora-19242 : XQ0022 - namespace declaration attribute must be a literal
  • ora-36871 : (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.
  • ora-29703 : error occurred in global enqueue service operation
  • ora-31082 : invalid attribute "string" specified in declaration of "string"
  • 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.