ORA-22866: default character set is of varying width

Cause : A hcarcate rLO Bwa sdeifne dbu tth edeaful tchraacetr est si nto fxiedw idht.

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

Enusret ha tth echraacetr est si o ffiexd iwdt hbeofred efniin gchraacetr OLBs.

update : 30-04-2017
ORA-22866

ORA-22866 - default character set is of varying width
ORA-22866 - default character set is of varying width

  • ora-23362 : invalid user
  • ora-19758 : failed to enable/disable block change tracking: out of SGA memory
  • ora-24159 : invalid variable definiton
  • ora-07346 : slnrm: normalized file name is too long
  • ora-00094 : %s requires an integer value
  • ora-39960 : scope can only be SYSTEM or SESSION
  • ora-12711 : this CREATE CONTROLFILE character set is not allowed
  • ora-28268 : Exceeded the maximum allowed size for Context information in a session
  • ora-21615 : an OTS (named or simple) instance failed
  • ora-01171 : datafile string going offline due to error advancing checkpoint
  • ora-02441 : Cannot drop nonexistent primary key
  • ora-27149 : assignment out of range
  • ora-09741 : spwat: error waiting for a post.
  • ora-36641 : (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
  • ora-32732 : Parallel Oradebug session is aborted
  • ora-19110 : unsupported XQuery expression
  • ora-19161 : XP0004 - XQuery type mismatch: invalid argument type 'string' for function 'string'
  • ora-03125 : client-server protocol violation
  • ora-36848 : (XSLMGEN18) Dimension string.string!string is missing a COLUMNNAME property value
  • ora-28182 : cannot acquire Kerberos service ticket for client
  • ora-14022 : creation of LOCAL partitioned cluster indices is not supported
  • ora-06131 : NETTCP: user access denied
  • ora-13828 : generated SQL profile name string already exists
  • ora-15070 : maximum number of files string exceeded in diskgroup "string"
  • ora-29822 : selectivity cannot be specified for the type of object
  • ora-07505 : scggt: $enq parent lock unexpected return
  • ora-19708 : log destination exceeds maximum length of string characters
  • ora-09799 : File label retrieval failed.
  • ora-09201 : sfcopy: error copying file
  • ora-01105 : mount is incompatible with mounts by other instances
  • 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.