How to see the character set of your database?
select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',
'NLS_LANGUAGE', 'LANGUAGE',
'NLS_TERRITORY', 'TERRITORY') name,
value from v$nls_parameters
WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY')
From result above, insert into first line of bat file. Before expdp statement.
Become like this
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
expdp username/password@database_Instance_name directory=EXPORT_DIR dumpfile=FULL_EXP_database.dmp logfile=full_exp_database.log full=y compression=all
By: JF
0 Comments