It is possible in Oracle 8i to directly change the character set of a
database. This can only be done, however, if the new character set is
a strict superset of the original character set. For instance,
according to 8.1.6 documentation, the conversion can be made from the
US7ASCII character set to three other character sets which are strict
supersets:
Current Character Set New Character Set
US7ASCII WE8ISO8859P1
US7ASCII ALT24UTFFSS
US7ASCII UTF8
To change the character set from US7ASCII to UTF8, execute the
following:
SVRMGR> STARTUP MOUNT;
SVRMGR> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SVRMGR> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SVRMGR> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SVRMGR> ALTER DATABASE OPEN;
SVRMGR> ALTER DATABASE CHARACTER SET UTF8;
SVRMGR> SHUTDOWN IMMEDIATE; — OR NORMAL
SVRMGR> STARTUP;
In cases where the new character set is not a strict superset of the
original character set, a full database export/import is necessary.