Oracle 9i Modify Character Set to UTF8 method (Chinese) __oracle

1, if the default Value of Oracle 9i,national CharSet is installed, it is al16utf16.
If you're going to replace AL16UTF16 with UTF8,
According to the previous method
Update sys.props$
Set value$ = ' UTF8 ' WHERE name = ' Nls_nchar_characterset '; There's going to be a problem.
There is no information in Oracle that fully reflects CharSet.
So, when insert in table, the value is set to AL16UTF16, only the default space is set to UTF8.

2, so this should change.
$ Sqlplus '/as Sysdba '
Sql> SHUTDOWN IMMEDIATE;
sql> STARTUP MOUNT EXCLUSIVE;
sql> ALTER SYSTEM ENABLE restricted session;
sql> ALTER SYSTEM SET job_queue_processes=0;
sql> ALTER SYSTEM SET aq_tm_processes=0;
sql> ALTER DATABASE OPEN;
sql> ALTER DATABASE National CHARACTER SET UTF8;
Sql> SHUTDOWN IMMEDIATE;
Sql> STARTUP;

It is OK to follow the above procedure, but there may be ' Ora-12717:cannot ALTER DATABASE national CHARACTER SET '
NCLOB data exists ' This kind of hint information

There are two ways to solve this problem

One is, using the Internal_use keyword to modify the locale, there is a use of re-create, but re-create a bit complicated, so please use Internal_use,
$ Sqlplus '/as Sysdba '
Sql> SHUTDOWN IMMEDIATE;
sql> STARTUP MOUNT EXCLUSIVE;
sql> ALTER SYSTEM ENABLE restricted session;
sql> ALTER SYSTEM SET job_queue_processes=0;
sql> ALTER SYSTEM SET aq_tm_processes=0;
sql> ALTER DATABASE OPEN;
sql> ALTER DATABASE National CHARACTER SET internal_use UTF8;
Sql> SHUTDOWN immed

If you follow the above procedure, national CharSet has no problem with regional settings