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 : 25-04-2017
ORA-22859

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

  • ora-32644 : this function is not allowed outside of MODEL clause
  • ora-33443 : (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.
  • ora-36612 : (XSLMS01) invalid OLAP message number: value
  • ora-35095 : (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.
  • ora-22329 : cannot alter a non-object type
  • ora-39032 : function string is not supported in string jobs
  • ora-30734 : cannot specify scope constraint on ref column with rowid
  • ora-06710 : TLI Driver: send interrupt break message failed
  • ora-27150 : attempt to notify process of pending oradebug call failed
  • ora-00335 : online log string: No log with this number, log does not exist
  • ora-30130 : invalid parameter key type received
  • ora-25176 : storage specification not permitted for primary key
  • ora-09751 : pw_attachPorts: server call pws_attach failed.
  • ora-13025 : polygon does not close
  • ora-34276 : (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
  • ora-26011 : Cannot load type string into column string in table string
  • ora-19282 : XQ0068 - It is a static error if a Prolog contains more than one xmlspace declaration
  • ora-33048 : (XSAGDNGL23) In AGGMAP workspace object, the relation workspace object and the relation workspace object are both over the same base dimension.
  • ora-36726 : (XSALERR00) The character 'character' is not a valid format specifier for the ALLOCATE error log.
  • ora-29553 : class in use: string.string
  • ora-26098 : direct path context is not prepared
  • ora-31222 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.
  • ora-26669 : parameter string inconsistent with parameter string
  • ora-06102 : NETTCP: cannot allocate context area
  • ora-28337 : the specified index may not be defined on an encrypted column
  • ora-01496 : specified chain row table form incorrect
  • ora-16529 : bad sender id
  • ora-19913 : unable to decrypt backup
  • ora-01784 : RECOVERABLE cannot be specified with database media recovery disabled
  • ora-30075 : TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint
  • 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.