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 : 22-08-2017
ORA-22859

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

  • ora-25283 : either agent's name or address needed for non-repudiation
  • ora-02817 : Read failed
  • ora-38904 : DML error logging is not supported for LOB column "string"
  • ora-01277 : file 'string' already exists
  • ora-01315 : Log file has been added or removed during select
  • ora-19569 : no device is allocated to this session
  • ora-16585 : illegal operation on a primary site
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • ora-29292 : file rename operation failed
  • ora-29505 : AS keyword is invalid in CREATE JAVA CLASS or RESOURCE
  • ora-31507 : %s parameter value longer than maximum length string
  • ora-02365 : error seeking in file: string
  • ora-35280 : (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] USING aggmap-name [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [THREADS #]
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-30742 : cannot grant SELECT privilege WITH HIERARCHY OPTION on this object
  • ora-16731 : error executing dbms_logstdby.unskip_txn procedure
  • ora-00059 : maximum number of DB_FILES exceeded
  • ora-24307 : invalid length for piece
  • ora-12620 : TNS:requested characteristic not available
  • ora-04062 : %s of string has been changed
  • ora-29328 : too many datafiles in this tablespace 'string'
  • ora-30653 : reject limit reached
  • ora-31478 : could not detach LogMiner session after change set advance
  • ora-25291 : Buffer does not exist for the specified queue
  • ora-01954 : DEFAULT ROLE clause not valid for CREATE USER
  • ora-39208 : Parameter string is invalid for string jobs.
  • ora-22167 : given trim size [string] must be less than or equal to [string]
  • ora-39777 : data saves are not allowed when loading lob columns
  • ora-16764 : redo transport service to a standby database is offline
  • ora-02456 : The HASH IS column specification must be NUMBER(*,0)
  • 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.