oracle基础教程(8)oracle修改字符集 1.用dba连接数据库 -->sqlplus / as sysdba 2.查看字符集 -->SELECT parameter, value FROM v$nls_parameters WHERE parameter LIKE '%CHARACTERSET'; 好像结果: PARAMETER ---------------------------------------------------------------- VALUE -------
1.登录sys关闭服务 [oracle@t-e ~]$ export ORACLE_SID=kamiltest1 [oracle@t-e ~]$ sqlplus / as sysdba SQL>shutdown immediate ; 2.修改字符集 SQL > startup mount ; SQL > alter system enable restricted session ; SQL > alter system set JOB_QUEUE_PROCESSES=; SQL
最近在做修改字符集的实验,悲剧的是修改后重启,数据库启动不了. SQL> alter system set nls_language='AMERICAN' scope = spfile; SQL> alter system set nls_territory='AMERICAN' scope=spfile; SQL> shutdown immediate; SQL> startup ORA-12700: invalid NLS parameter value (nls_ter
Preface Today,I'm gonna say something what is related with the character set in Oracle database,the scenarios in changing character set from UTF8 to ZHS16GBK and the contra way as well. It' not recommended to modify character set in Oracl