纠正Oracle【12C】字符集

(1)查看字符集复制代码 代码如下:select *
from v$nls_parameters where parameter=’NLS_CHARACTERSET’select * from
nls_database_parameters where parameter=’NLS_CHARACTERSET’select *
from props$ where name=’NLS_CHARACTERSET'(2)查看国家字符集复制代码 代码如下:select * from
nls_database_parameters where
parameter=’NLS_NCHAR_CHARACTERSET’select * from
nls_database_parameters where
parameter=’NLS_NCHAR_CHARACTERSET’select * from props$ where
name=’NLS_NCHAR_CHARACTERSET'(3)查看oracle server端的字符集复制代码 代码如下:select userenv(‘language’)
from dual(4)DataFile操作复制代码
代码如下:–DataFile联机ALTER TABLESPACE BSS11 ONLINEALTER DATABASE
‘BSS_03.dbf’ ONLINE

  1. select
    userenv(‘language’) from dual; //查看系统字符集编码
  2. select *
    from nls_database_parameters where parameter in
    (‘NLS_CHARCTERSET’,’NLS_NCHAR_CHARACTERSET’);
  3. shutdown
    immediate
  4. startup
  5. alter
    session set sql_trace=true;
  6. alter
    system enable restricted session;
  7. show
    parameter job_queue_processes;
  8. alter
    system set job_queue_processes=0;
  9. alter
    system set aq_tm_processes=0;
  10. alter
    database character set INTERNAL_USE AL32UTF8;
  11. update
    props$ set VALUE$=’UTF8′ where
    NAME=’NLS_NCHAR_CHARACTERSET’;