更改数据库字符集编码

最新推荐文章于 2024-09-30 09:09:52 发布

niuniudan1984

最新推荐文章于 2024-09-30 09:09:52 发布

阅读量88

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/niuniudan1984/article/details/83738018

版权

sqlplus /nolog

connect sys as sysdba

--------------------------------------------------------
-- these parameters have to be changed
-- in order to change characterset
--------------------------------------------------------
Alter system set job_queue_processes=0 scope=spfile;
Alter system set aq_tm_processes=0 scope=spfile;

shutdown immediate
startup nomount
alter database mount exclusive;
alter database open;
alter system enable restricted session;
purge dba_recyclebin;
alter database character set internal_use AL32UTF8;
alter database national character set internal_use UTF8;

shutdown immediate
startup