imp导入数据时报:
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
SQL>select * from nls_database_parameters;
NLS_CHARACTERSET AL32UTF8
SQL> select * from nls_instance_parameters ;
PARAMETER VALUE
------------------------------------------------------------ -----------------------------------------------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
PARAMETER VALUE
------------------------------------------------------------ -----------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
imp/exp 前运行:
export NLS_LANG =american_america.AL32UTF8
NLS_LANG=american_america.ZHS16GBK
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
[oracle@ora1 ~]$ exp \'/ as sysdba \' file=a.dmp transport_tablespace=y tablespaces=users