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导出文件后将客户端的字符集设置还原回去