How to change Character set for oracle 8i databases
What is way to change CHARACTER SET for the database ?
I have created Database in Oracle 8.1.6 with CHARACTER SET WE8ISO8859P1. Since this is 8-bit character set it will not support unicode charachetrs. I need the columns to accept NVACHAR / NCHAR values.
So as to change CHARACTER SET, i already workout following process.
1. SHUTDOWN IMMEDIATE; " BACKED UP DATABASE "
2. STARTUP MOUNT;
3. ALTER SYSTEM ENABLE RESTRICTED SESSION;
4. ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0;
5. ALTER DATABASE OPEN;
6. ALTER DATABASE CHARACTER SET AL16UTF16;
SETP 6 HAS GIVEN FOLLOWING ERROR
ALTER DATABASE CHARACTER SET AL16UTF16
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
Can any one help me out ? Do i need to recreate database again? what should be ideal character set for my scenario ?