EXP-00091 error resolution when backing up Oracle on Linux

EXP-00091 error resolution when backing up Oracle on Unix/linux

Error resolution when backing up data on Unix/linux

Exp-00091:exporting questionable statistics. Workarounds

Today's EXP data finds the following error:

Exp-00091:exporting questionable statistics.

. . Exporting table TAXVOU3129 2904185 rows Exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table Tips_budget_subject_income 2297 rows Exported

Exp-00091:exporting questionable statistics.

. . Exporting table TRBUDGETBILL3128 0 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table TRDRAWBACKBILL3128 0 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table TRECODEINFO104 849 rows exported

Exp-00091:exporting questionable statistics.

. . Exporting table TRECODEINFO9100 1 rows exported

Exp-00091:exporting questionable statistics.

. . Exporting table TRREMOVEBILL3128 0 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table TRSHAREBILL3128 0 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table Type_table_relation rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table Untax_billprice 0 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table Untax_billprintery 0 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table Untax_chargekind 0 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table Untax_itemsort 0 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table USERS 1 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table User_role rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table View_list 0 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. . Exporting table View_manager 0 rows exported

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. Exporting synonyms

. Exporting views

. Exporting stored Procedures

. Exporting operators

. Exporting referential integrity constraints

. Exporting triggers

. Exporting indextypes

. Exporting bitmap, functional and extensible indexes

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

Exp-00091:exporting questionable statistics.

. Exporting Posttables Actions

. Exporting materialized views

. Exporting snapshot logs

. Exporting job queues

. Exporting refresh groups and children

. Exporting dimensions

. Exporting Post-Schema procedural objects and actions

. Exporting statistics

Export terminated successfully with warnings.

Workaround:

SELECT * from Nls_database_parameters t where t.parameter= ' Nls_characterset '

Or
SELECT * from v$nls_parameters where parameter= ' nls_characterset ';
The query value is: ZHS16GBK

Then Vi/home/oracle/.bash_profile

Export Nls_lang=american_america. Zhs16gbk

Source/home/oracle/.bash_profile

Under Windows:

Set Nls_lang=american_america. Zhs16gbk

(Define system environment variables to be available for permanent entry)

or set environment variables in the registry

Hkey_local_machine\software\oracle\key_oradb10g_home1\nls_lang

Modify Nls_lang to change it to American_america. Zhs16gbk

and then the EXP

. . Exporting table TAXVOU3129 2913768 rows Exported

. . Exporting table Tips_budget_subject_income 2297 rows Exported

. . Exporting table TRBUDGETBILL3128 0 rows exported

. . Exporting table TRDRAWBACKBILL3128 0 rows exported

. . Exporting table TRECODEINFO104 849 rows exported

. . Exporting table TRECODEINFO9100 1 rows exported

. . Exporting table TRREMOVEBILL3128 0 rows exported

. . Exporting table TRSHAREBILL3128 0 rows exported

. . Exporting table Type_table_relation rows exported

. . Exporting table Untax_billprice 0 rows exported

. . Exporting table Untax_billprintery 0 rows exported

. . Exporting table Untax_chargekind 0 rows exported

. . Exporting table Untax_itemsort 0 rows exported

. . Exporting table USERS 1 rows exported

. . Exporting table User_role rows exported

. . Exporting table View_list 0 rows exported

. . Exporting table View_manager 0 rows exported

. Exporting synonyms

. Exporting views

. Exporting stored Procedures

. Exporting operators

. Exporting referential integrity constraints

. Exporting triggers

. Exporting indextypes

. Exporting bitmap, functional and extensible indexes

. Exporting Posttables Actions

. Exporting materialized views

. Exporting snapshot logs

. Exporting job queues

. Exporting refresh groups and children

. Exporting dimensions

. Exporting Post-Schema procedural objects and actions

. Exporting statistics

Export terminated successfully without warnings.