Oracle EXP-00091 Solution

Solution to Oracle EXP-00091 [SQL] EXP-00091: Exporting problematic statistics. Www.2cto.com .. export table WF_GENERAL export EXP-00091: Exporting problematic statistics.... Export table WF_PLAN_BOOK export EXP-00091: Exporting problematic statistics.... Export table WF_TEACHER_REMUNERATION export <span style = "color: # ff0000;"> EXP-00091: Exporting problematic statistics. </Span>. exporting synonym. exporting view. exporting the stored procedure. exporting operator. importing integrity constraints. exporting trigger. exporting index type. exporting table activity later. exporting the materialized view. exporting snapshot logs. exporting job queue. exporting refresh group and sub-group. exporting dimension. exporting post-schema process objects and operations. exporting statistics Windows: (1) Let's check the value of NLS_CHARACTERSET In the DB [SQL] select * from nls_database_parameters t where t. parameter = 'nls _ CHARACTERSET '; or [SQL] select * from v $ nls_parameters where parameter = 'nls _ CHARACTERSET'; (2) view N in Environment Variables LS_LANG: The system number when the value is HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMExx/and xx indicates that there are multiple ORACLE_HOME instances.


3) if the environment variables in the DB in NLS_LANG AND exp are indeed different, it will cause the problem just now. In Windows, you can directly modify the NLS_LANG value in the registry. Use the NLS_LANG value in the database as the standard. Supplement Linux: 1) Check the environment variable NLS_LANG: [oracle @ MWSG1: ~] $ Echo $ NLS_LANG 2) set the exp environment variable according to the NLS_CHARACTERSET (1): WINNT> set NLS_LANG = AMERICAN_AMERICA.AL32UTF8 [oracle @ MWSG1: ~] $ Export NLS_LANG = AMERICAN_AMERICA.AL32UTF8 [oracle @ MWSG1: ~] $ Echo $ NLS_LANGAMERICAN_AMERICA.AL32UTF8