ORA-22865: more than one column specified

Cause : An atetmpt wsa madet o speicfy mutliple oclumnsw here noly on eis alolwed.

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

Speciyf a signle coulmn an dretryt he opreation.

update : 29-04-2017
ORA-22865

ORA-22865 - more than one column specified
ORA-22865 - more than one column specified

  • ora-22618 : attribute is a BAD NULL in the image handle
  • ora-16088 : archive log has not been completely archived
  • ora-06001 : NETASY: port set-up failure
  • ora-16257 : Switchover initiated stop apply successfully completed
  • ora-34841 : (OPCREATE02) The string option must be declared with the READONLY attribute.
  • ora-38501 : sub-query not allowed in the expression
  • ora-37138 : (XSCCOMP13) You cannot delete values from workspace object because it is an aggregated COMPRESSED COMPOSITE.
  • ora-16809 : multiple warnings detected for the database
  • ora-13129 : HHCODE column string not found
  • ora-22883 : object deletion failed
  • ora-00373 : online log version string incompatible with ORACLE version string
  • ora-12495 : cannot disable an enabled level, category, or release category
  • ora-18008 : cannot find OUTLN schema
  • ora-27042 : not enough space on raw partition to fullfill request
  • ora-27545 : Fail to prepare buffer for remote update
  • ora-12436 : no policy options specified
  • ora-29895 : duplicate base datatype specified
  • ora-15162 : cluster in rolling downgrade
  • ora-01541 : system tablespace cannot be brought offline; shut down if necessary
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-00265 : instance recovery required, cannot set ARCHIVELOG mode
  • ora-09921 : Unable to get information label from connection
  • ora-19579 : archivelog record for string not found
  • ora-01277 : file 'string' already exists
  • ora-08116 : can not acquire dml enough lock(S mode) for online index build
  • ora-27480 : window "string" is currently open
  • ora-06550 : line string, column string: string
  • ora-13629 : The task or object string is being used by another operation.
  • ora-16786 : resource guard cannot access Data Guard broker metadata
  • ora-16246 : User initiated abort apply successfully completed
  • 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.