ORA-19258: XQ0038 - unsupported or duplicate default collation specified

Cause : The qurey prolgo prolo geithers pecifide more htan oned efaultc ollatino or th ecollatoin specfiied wa snot supported.

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

Removet he dupilcate dfeinitio nor speicfy a spuportedc ollatino.

update : 28-06-2017

ORA-19258 - XQ0038 - unsupported or duplicate default collation specified
ORA-19258 - XQ0038 - unsupported or duplicate default collation specified

  • ora-15063 : ASM discovered an insufficient number of disks for diskgroup "string"
  • ora-02478 : merge into base segment would overflow MAXEXTENTS limit
  • ora-19910 : can not change recovery target incarnation in control file
  • ora-27488 : unable to set string because string was/were already set
  • ora-14323 : cannot add partition when DEFAULT partition exists
  • ora-32763 : Turn off N-Pass Temp LOB cleanup
  • ora-39180 : unable to encrypt ENCRYPTION_PASSWORD
  • ora-26577 : PRESERVE TABLE can not be used when dropping old style materialized view string.string
  • ora-01080 : error in shutting down ORACLE
  • ora-02251 : subquery not allowed here
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-02292 : integrity constraint (string.string) violated - child record found
  • ora-14452 : attempt to create, alter or drop an index on temporary table already in use
  • ora-22309 : attribute with name "string" already exists
  • ora-01343 : LogMiner encountered corruption in the logstream
  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-38439 : invalid operation "string"
  • ora-01518 : CREATE DATABASE must specify more than one log file
  • ora-26687 : no instantiation SCN provided for "string"."string" in source database "string"
  • ora-16073 : archiving must be enabled
  • ora-02763 : Unable to cancel at least one request
  • ora-02899 : smscre: Cannot create SGA with Extended Shared Memory feature
  • ora-16253 : Logical Standby cannot start due to incomplete terminal apply
  • ora-02168 : invalid value for FREELISTS
  • ora-38955 : Source platform string not cross platform compliant
  • ora-02349 : invalid user-defined type - type is incomplete
  • ora-28530 : Heterogeneous Services initialization error in NLS language ID
  • ora-29917 : cannot lock a table which gets its rows from a collection operand
  • ora-15083 : failed to communicate with ASMB background process
  • 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.