Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists

Solution ID:ORA-12717

Type: Oracle

Cause

NCLOB, NCHAR or NVARCHAR2 data changed the representation to Unicode when converting to a multibyte character set and must be migrated.

Actions

Remove NCLOB, NCHAR or NVARCHAR2 data as listed in the alert file. The above type data can be migrated by methods such as import/export.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/1205609


https://community.oracle.com/message/1205592


https://community.oracle.com/message/10341360


https://community.oracle.com/message/2397956


https://community.oracle.com/message/2122318


https://community.oracle.com/message/1592972


https://community.oracle.com/message/613162


https://community.oracle.com/message/10540244


Browse all solutions to database errors from Oracle, MS SQL, or MySQL