Shulou(Shulou.com)06/01 Report--

The following error message appears when exporting data with exp:

1) query the character set of the database

Select userenv ('language') from dual

2) option I:

Set the NLS_LANG environment variable for Linux operating system

[oracle@node1] $$export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Or modify the environment variable .bash _ profile file under the oracle user

# .bash _ profile# Get the aliases and functionsif [- f ~ / .bashrc]; then. ~ / .bashrcfi # User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHTMP=/tmp;export TMPTMPDIR=$TMP;export TMPDIRORACLE_BASE=/opt/oracle;export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;export ORACLE_HOMEORACLE_SID=report;export ORACLE_SIDLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHPATH=$ORACLE_HOME/bin:$PATH; export PATHLANG=en_US.utf8; export LANGNLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG

The method to modify the environment variables of the Window system is:

C:\ > set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Option 2:

The statistics field statistics is set to none.

Exp user/pwd@db file=/home/a.dmp log=/home/a.log statistics=none

No more wrong reports. However, this approach is equivalent to not exporting statistics due to character set inconsistency errors, which will not be available for import, and can only be re-collected if necessary.

Therefore, for this kind of error of exp reporting EXP-00091, there are two ways of workaround, but the recommended one is definitely scheme 1, and the information derived is the most comprehensive.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.