Shulou(Shulou.com)05/31 Report--

This article will explain in detail about exp backup export Times EXP-00091: Exporting questionable statistics "what to do with the error, the editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article."

Problem phenomenon

When making exp backup to ORACLE database, export Times EXP-00091: Exporting questionable statistics "error: details are as follows:

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . Exporting table test 12 rows exported

EXP-00091: Exporting questionable statistics.

. . Exporting table users 129 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

The cause of the problem:

This problem is caused by the inconsistency between the database character set and the NLS_LANG of the operating system.

Treatment method:

Query the character set information of the database

SQL > select userenv ('language') from dual

USERENV ('LANGUAGE')

AMERICAN_AMERICA.WE8ISO8859P1

Set the NLS_ language value of the operating system

Export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

Rerun the database export command

Exp system/oracle file='/tmp/full.dmp' full=y

This is the end of this article about "exp backup Export Times EXP-00091: Exporting questionable statistics what to do with mistakes". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.