Cause: the NLS_LANG parameter of the client connection is inconsistent with the NLS_CHARACTERSET In the DB. view the server parameters:
Select * from nls_database_parameters t where t. parameter = 'nls _ CHARACTERSET'
Or
Select * from v $ nls_parameters where parameter = 'nls _ CHARACTERSET ';
SQL> select * from v $ nls_parameters where parameter = 'nls _ CHARACTERSET ';
PARAMETER VALUE
---------------------------------------------------------------------
NLS_CHARACTERSET AL32UTF8
Client connection settings:
WINNT> set NLS_LANG = AMERICAN_AMERICA.AL32UTF8
LINUX> export NLS_LANG = AMERICAN_AMERICA.AL32UTF8s
I generally write it as bat to do this:
Set NLS_LANG = AMERICAN_AMERICA.AL32UTF8
D: \ Oracle \ product \ 10.2.0 \ client_1 \ BIN \ exp.exe PESP_USER/PESP_USER @ DBUTF8 file = "f: \ pesp_db_20127.dmp" log = f: \ exp. log owner = PESP_USER