Linux-CentOS6.50-ORACLE备份exp/还原imp操作，还原后数据库字段注释为???

导出脚本中增加：

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

或者vi ~/.bash_profile增加：

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 

source ~/.bash_profile  #生效环境

数据库字符集

SELECT DISTINCT (NLS_CHARSET_NAME(CHARSETID)) CHARACTERSET,DECODE(TYPE#,1,DECODE(CHARSETFORM,1,'VARCHAR2',2,'NVARCHAR2','UNKOWN'),9,DECODE(CHARSETFORM,1,'VARCHAR',2,'NCHARVARYING','UNKOWN'),96,DECODE(CHARSETFORM, 1, 'CHAR', 2, 'NCHAR', 'UNKOWN'),112,DECODE(CHARSETFORM, 1, 'CLOB', 2, 'NCLOB', 'UNKOWN')) TYPES_USED_IN FROM SYS.COL$ WHERE CHARSETFORM IN (1, 2) AND TYPE# IN (1, 9, 96, 112);

select * from nls_database_parameters;

select * from v$nls_parameters;