Doc ID:

You cannot have more than 2 charactersets defined in Oracle: The NLS_CHARACTERSET is used for CHAR, VARCHAR2, CLOB columns; The NLS_NCHAR_CHARACTERSET is used for NCHAR, NVARCHAR2, NCLOB columns. NLS_NCHAR_CHARACTERSET is defined when the database is created . and specified with the CREATE DATABASE command. ................
................