Oracle DBA, How To, Error, Cause and Action

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

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


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

No comments:

Post a Comment

Thanks for your comment.