Exporting questionable statistics error handling occurred in the export ORACLE database under Linux system
- 2020-05-30 21:13:46
- OfStack
Environment: both the A machine and the B machine are LINUX systems. However, since the B machine has run out of space, we stop the service of continuously operating the database and prepare to export on the A machine.
Export statement exp user/password @sid file= 0320.dmp
Errors with Exporting questionable statistics. Occur repeatedly during the export process.
Internet 1 search, it is a character set problem.
Use statements to view the database's character set.
select *from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';
or
selct *from v$nls_parameters where parameter='NLS_CHARACTERSET';
The result is 1. Both the A and B machines are ZHS16GBK. Strange. Why not? If I look at the system character set of A machine again, I find that it is in simplified Chinese. Is that the problem?
Use it on the A machine
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
If you export it again, there will be no errors.
It turned out that the system had the wrong character set, not ORACLE.
Export statement exp user/password @sid file= 0320.dmp
Errors with Exporting questionable statistics. Occur repeatedly during the export process.
Internet 1 search, it is a character set problem.
Use statements to view the database's character set.
select *from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';
or
selct *from v$nls_parameters where parameter='NLS_CHARACTERSET';
The result is 1. Both the A and B machines are ZHS16GBK. Strange. Why not? If I look at the system character set of A machine again, I find that it is in simplified Chinese. Is that the problem?
Use it on the A machine
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
If you export it again, there will be no errors.
It turned out that the system had the wrong character set, not ORACLE.