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



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

Answer / guest

Cause: CLOB data changes representation to Unicode when
converting to a multibyte character set and must be migrated

Action: Remove CLOB data as listed in the alert file. CLOB
data can be migrated by methods such as import/export

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00347: log string of thread string, expected block size string doesn't match string

1 Answers  


ORA-36740: A CHILDLOCK was detected in your valueset

1 Answers  


SQL*Loader-00108: Invalid number of logical records to load

1 Answers  


ORA-29552: verification warning: string

1 Answers  


PLS-00202: type 'string' must be declared

1 Answers  






ORA-16582: Could not edit instance specific property.

1 Answers  


O2U-00202: Invalid data passed to function

1 Answers  


PLS-00503: RETURN <value> statement required for this return from function

1 Answers  


ORA-26660: Invalid action context value for string

1 Answers  


ORA-16808: unable to resolve the full path name

1 Answers  


SQL-02122: Invalid OPEN or PREPARE for this database connection

1 Answers  


ORA-28293: No matched Kerberos Principal found in any user entry

1 Answers  


Categories