日期:2014-05-16  浏览次数:20409 次

修改oracle数据库编码

首先通过sqlplus连接数据库,将正在运行的数据库实例关掉(例如将数据库编码改为utf-8)

具体操作如下:

?

SQL>?? shutdown?? immediate;
SQL>?? startup?? mount;
SQL>?? alter?? system?? enable?? restricted?? session;
SQL>?? alter?? system?? set?? job_queue_processes=0;
SQL>?? alter?? database?? open;
SQL>?? alter?? database?? character?? set?? internal_use?? UTF8;
SQL>?? shutdown?? immediate;
SQL>?? startup