Friday, March 27, 2009

Exporting Questionable Stats

If you get "Exporting Questionable Stats" when running Oracle exp :-

1) Find your database's NLS_CHARACTERSET

SQL> select * from v$nls_parameters where parameter = 'NLS_CHARACTERSET';

PARAMETER VALUE
---------------------------------------- ----------------------------------------
NLS_CHARACTERSET AL32UTF8

2) Set NLS_LANG in the OS :-

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

3) Re-run the export