Question

如何修改oracle字符集为UTF8

Answer 1

执行如下语句即可
sqlplus system/orcl@orcl

select * from v$nls_parameters;

$sqlplus /nolog

conn / as sysdba

SHUTDOWN IMMEDIATE;

STARTUP MOUNT EXCLUSIVE;

ALTER SYSTEM ENABLE RESTRICTED SESSION;

ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

ALTER SYSTEM SET AQ_TM_PROCESSES=0;

ALTER DATABASE OPEN;

ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE UTF8;

SHUTDOWN immediate;

startup;

/