网站首页  汉语字词  英语词汇  考试资料  写作素材  旧版资料

请输入您要查询的范文:

 

标题 Oracle修改默认字符编码
范文
    --查看Oracle数据库字符集:
    Sql代码
    select userenv('language') from dual;
    查询结果:
    SIMPLIFIED CHINESE_CHINA.AL32UTF8
    --修改oracle数据库字符集:(在SQL Plus中)
    Sql代码
    sql> conn / as sysdba;
    sql> shutdown immediate;
    database closed.
    database dismounted.
    oracle instance shut down.
    sql> startup mount;
    oracle instance started.
    total system global area 135337420 bytes
    fixed size 452044 bytes
    variable size 109051904 bytes
    database buffers 25165824 bytes
    redo buffers 667648 bytes
    database mounted.
    sql> alter system enable restricted session;
    system altered.
    sql> alter system set job_queue_processes=0;
    system altered.
    sql> alter system set aq_tm_processes=0;
    system altered.
    sql> alter database open;
    database altered.
    sql> alter database character set internal_use AL32UTF8;
    sql> shutdown immediate;
    sql> startup;
    修改oracle用户的NLS_LANG
    编辑/home/oracle/.bash_profile
    Bash代码
    export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
随便看

 

在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板,是学习及工作的有利工具。

 

Copyright © 2002-2024 cuapp.net All Rights Reserved
更新时间:2025/5/15 4:37:34