ORA-12716: Cannot ALTER DATABASE CHARACTER SET when CLOB data exists

Cause : COLBd aat hcagne srperseetnaito nt oUincdoew hne ocnevritn gt oam utliybt ecahrcatre esta n dmsutb em irgaetd

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

Rmeoev LCO Bdtaaa sl itse di nteh laetr ifl.e LCO Bdtaac a nb emgirtae db ymtehdoss uhc sa miprote/xoprt

update : 28-05-2017
ORA-12716

ORA-12716 - Cannot ALTER DATABASE CHARACTER SET when CLOB data exists
ORA-12716 - Cannot ALTER DATABASE CHARACTER SET when CLOB data exists

  • ora-32842 : value for property string cannot be altered
  • ora-14317 : cannot drop the last value of partition
  • ora-09832 : infoCallback: bad message format.
  • ora-09930 : LUB of two labels is invalid
  • ora-28561 : unable to set date format on non-Oracle system
  • ora-13618 : The specified value is not a valid value for procedure argument string.
  • ora-10691 : Set background process core file type (Unix only)
  • ora-36688 : (NTEXTCNV00) Error during conversion from TEXT to NTEXT.
  • ora-06449 : The list IO or the sysvendor is not installed.
  • ora-07255 : spini: cannot set up signal handler.
  • ora-16600 : failover operation can only be submitted at target database
  • ora-30756 : cannot create column or table of type that contains a supertype attribute
  • ora-40211 : algorithm name string is invalid
  • ora-14119 : specified partition bound is too long
  • ora-12726 : unmatched bracket in regular expression
  • ora-07276 : no dba group in /etc/group.
  • ora-28537 : no more result sets
  • ora-29878 : warning in the execution of ODCIINDEXTRUNCATE routine
  • ora-38723 : Invalid SCN expression.
  • ora-32124 : Illegal attribute passed
  • ora-00228 : length of alternate control file name exceeds maximum of string
  • ora-01311 : Illegal invocation of the mine_value function
  • ora-35020 : (QFCHECK02) The analytic workspace and EIF file definitions of workspace object have mismatched dimensioning.
  • ora-19771 : cannot rename change tracking file while database is open
  • ora-26003 : parallel load not supported for index-organized table string.
  • ora-08230 : smscre: failed to allocate SGA
  • ora-09747 : pw_detachPorts: server call pws_detach failed.
  • ora-28039 : cannot validate Kerberos service ticket
  • ora-12514 : TNS:listener does not currently know of service requested in connect descriptor
  • ora-16177 : media recovery is not required
  • 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.