如何查看及修改oracle编码格式方法

如何查看及修改oracle编码格式方法

--查看oracle数据库字符集：

selectuserenv('language')fromdual;

查询结果：

SIMPLIFIEDCHINESE_CHINA.AL32UTF8

--修改oracle数据库字符集：（在SQLPlus中）

sql>conn/assysdba;

sql>shutdownimmediate;

databaseclosed.

databasedismounted.

oracleinstanceshutdown.

sql>startupmount;

oracleinstancestarted.

totalsystemglobalarea135337420bytes

fixedsize452044bytes

variablesize109051904bytes

databasebuffers25165824bytes

redobuffers667648bytes

databasemounted.

sql>altersystemenablerestrictedsession;

systemaltered.

sql>altersystemsetjob_queue_processes=0;

systemaltered.

sql>altersystemsetaq_tm_processes=0;

systemaltered.

sql>alterdatabaseopen;

databasealtered.

sql>alterdatabasecharactersetinternal_useZHS16GBK

sql>shutdownimmediate;

sql>startup;