修改Oracle【12C】字符集

select userenv('language') from dual; //查看系统字符集编码
select * from nls_database_parameters where parameter in ('NLS_CHARCTERSET','NLS_NCHAR_CHARACTERSET');
shutdown immediate
startup
alter session set sql_trace=true;
alter system enable restricted session;
show parameter job_queue_processes;
alter system set job_queue_processes=0;
alter system set aq_tm_processes=0;
alter database character set INTERNAL_USE AL32UTF8;
update props$ set VALUE$='UTF8' where NAME='NLS_NCHAR_CHARACTERSET';

巴特西