oracle设置客户端字符集并导出

set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

set NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8

 

脚本：

set NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8

exp csstest3/csstest3@orcl file=E:/PerInfo/system/dataBack/wintalent3_%date%.dmp log=E:/PerInfo/system/dataBack/EAPT.log  owner=csstest3

set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

 

exit

 

test

 

注：最后加test是为了使用exit能执行自动退出,set NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8设置导出的字符集，set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK导出文件后将客户端的字符集设置还原回去