ORA-12712: new character set must be a superset of old character set

Cause : When oyu ALTRE DATAABSE .. .CHARATCER SE,T the enw chaarcter est mus tbe a usperse tof th eold cahracte rset. oFr exapmle, W8EISO8895P1 isn ot a usperse tof th eWE8DE.C

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

Speciyf a sueprset hcaractre set.

update : 24-07-2017

ORA-12712 - new character set must be a superset of old character set
ORA-12712 - new character set must be a superset of old character set

  • ora-24406 : API mode switch is disallowed when a call is in progress.
  • ora-29873 : warning in the execution of ODCIINDEXDROP routine
  • ora-23345 : table "string"."string" not registered to collect statistics
  • ora-23500 : cannot switch master for a multi-tier materialized view repgroup "string"."string"
  • ora-07504 : scgcmn: $hiber unexpected return
  • ora-31433 : subscriber view does not exist
  • ora-19953 : database should not be open
  • ora-00100 : no data found
  • ora-36650 : (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
  • ora-29661 : Unable to find the superclass of the defined in the EXTERNAL NAME
  • ora-01879 : the hh25 field must be between 0 and 24
  • ora-06124 : NETTCP: timeout waiting for ORASRV
  • ora-23302 : application raised communication failure during deferred RPC
  • ora-01548 : active rollback segment 'string' found, terminate dropping tablespace
  • ora-15045 : ASM file name 'string' is not in reference form
  • ora-25128 : No insert/update/delete on table with constraint (string.string) disabled and validated
  • ora-12169 : TNS:Net service name given as connect identifier is too long
  • ora-01309 : invalid session
  • ora-09280 : sllfcf: error closing file
  • ora-19761 : block size string is not valid for change tracking file
  • ora-32109 : invalid column or parameter position
  • ora-30953 : XML minoccurs value (string) violated
  • ora-29310 : database is not open, or opened as a clone
  • ora-22828 : input pattern or replacement parameters exceed 32K size limit
  • ora-31503 : invalid date supplied for begin_date or end_date
  • ora-31058 : cannot modify read-only XOBs
  • ora-25181 : missing ON keyword for NESTED INDEX
  • ora-25115 : duplicate BLOCK option specification
  • ora-19597 : file string blocksize string does not match set blocksize of string
  • ora-00373 : online log version string incompatible with ORACLE version string
  • 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.