又是一个oracle bug. 10g 在dbca建库时没有gb18030的字符集选择。
解决方法有2种，一是先用US7创建，然后改为gb18030,一是用dbca生成scripts,修改scripts,改为gb18030字符集，再执行scripts.
建库完成后，查看nls_characterset _parameters 确认。
如下是metalink上得到的答复：
这个metalink的产生还挺麻烦。
直接8008100366过去，还是下午5点多，metalink中文服务到6点。我选择了英文服务，
以为可以直接和工程师对话，结果也是hub,不过是英文的hub。痛苦的对话后，huber给我创建了一个tar，后来发现我说的GB,被听成了GP，结果写出来是GP18030，不幸中的万幸是，创建的是一个2级tar，所以处理速度应该还可以。
后面第一个回复我，问我是否使用了locale builder(lbuilder)，我感觉有些偏了，因为9i安装时不需要这个。
后来打了2次电话催，一次让工程师回电，没有收到；
后来打电话，找中文的服务，huber解释目前负责的是老美，老美还在睡觉呢，就帮我把负责的工程师切换到亚太，很快就回复了。
感觉以后要催，还是要找中文的。
QUESTION
=========
When I tried to create database with dbca, I select the character set from the
character sets list, but I can't find the ZHS32GB18030, which can be found when
I run dbca on Oracle 9i.
so My question is : does Oracle 10g doesn't support ZHS32GB18030 any longer?
or Is there a character set which contains ZHS32GB18030?
eos (end of section)
ANSWER
=======
Oracle still supports the character set ZHS32GB18030. But
DBCA not listing the characterset seems to be a new BUG.
I understand that your concern is to create a database with the characterset
ZHS32GB18030 . So , please follow the workaroud below.
+ Create a database selecting the characterset US7ASCII from the DBCA dropdown
list .
+ Then change the database characterset to ZHS32GB18030 with 'ALTER DATABASE '
command .
To change the characterset to ZHS32GB18030 from US7ASCII using 'alter database'
------------------------------------------------
Once the database with US7ASCII is created using DBCA , perform the following
steps :
SHUTDOWN IMMEDIATE;
-- make sure there is a database backup you can rely on, or create one
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET ZHS32GB18030;
-- a alter database takes typically only a few minutes or less,
-- it depends on the number of columns in the database, not the
-- amount of data.
SHUTDOWN;
New info : liyuefu@yahoo.com.cn : Thanks for kindly reply.
Can I create the scripts with dbca, and then change the script to use GB18030 ,
and then create database with new scripts?
14-NOV-06 05:56:47 GMT
.
UPDATE
======
Hi Yuefu,
Yes. You can do like that also. There shouldnot be any problem.
After creating the database you can query nls_characterset _parameters to confirm the character set.
--------