ORA-22954: This multiset operation is not supported for this element type.

Cause : The mlutiseto peratoin attmepted aws nots upporetd fort he netsed talbe eleemnt tyep.

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

Use as upporetd eleemnt tyep.

update : 21-09-2017

ORA-22954 - This multiset operation is not supported for this element type.
ORA-22954 - This multiset operation is not supported for this element type.

  • ora-31037 : Invalid XML attribute name string
  • ora-00721 : changes by release string cannot be used by release string
  • ora-40209 : setting % is invalid for % function
  • ora-22346 : Type has cyclical dependency. Should use CASCADE option
  • ora-15043 : ASM disk "string" is not a diskgroup member
  • ora-09966 : falure in translation while expanding ?/dbs/lk for lock file
  • ora-27205 : skgfpcn: sbtpccancel returned error
  • ora-22297 : warning: Open LOBs exist at transaction commit time
  • ora-30438 : unable to access named pipe 'string'
  • ora-27230 : OS system call failure
  • ora-29518 : name string resolved to an object in schema string that is not a Java class
  • ora-40287 : invalid data for model - cosine distance out of bounds
  • ora-06933 : CMX: error during attach
  • ora-14509 : specified VALIDATE INTO table form incorrect
  • ora-24065 : propagation for QUEUE string and DESTINATION string already disabled
  • ora-01607 : cannot add logfile to the specified instance
  • ora-01867 : the interval is invalid
  • ora-16551 : short string copied
  • ora-28039 : cannot validate Kerberos service ticket
  • ora-00345 : redo log write error block string count string
  • ora-06130 : NETTCP: host access denied
  • ora-01489 : result of string concatenation is too long
  • ora-23340 : incorrect resolution method string
  • ora-32165 : Cannot get XA environment
  • ora-31022 : Element not found
  • ora-13501 : Cannot drop SYSAUX tablespace
  • ora-19805 : recid string of string was deleted to reclaim disk space
  • ora-19595 : archivelog string already included in backup conversation
  • ora-28184 : global user cannot have proxy permissions managed in the directory
  • ora-24162 : name value pair list is full, cannot add another entry
  • 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.