Shulou(Shulou.com)05/31 Report--

This article mainly explains the "exp export file used by the character set is what", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "exp export file used by the character set of what" it!

The character set of the exp exported file is related to the value of the client-side NLS_LANG parameter. If there is only an exp file, you can identify the character set in the following ways:

1. On windows, you can use the UltraEdit tool to open the dmp file; on linux, you can use cat and the od command to view the contents of the dmp file, as follows:

[oracle@node3 ~] $cat emp.dmp | od-t x1 | head-2

0000000 03 03 54 45 58 50 4f 52 54 3a 56 31 31 2e 30 32

0000020 2e 30 30 0a 44 53 59 53 0a 52 54 41 42 4c 45 53

If you look at its second and third bytes, you can see that it is 0354.

two。 Convert 0354 in the first step to decimal

SQL > select to_number ('0354 from dual xxxx')

TO_NUMBER ('0354')

-

eight hundred and fifty two

Get 852

3. According to the obtained decimal number, view the corresponding character set

SQL > select nls_charset_name (852) from dual

NLS_CHAR

-

ZHS16GBK

Thank you for your reading, the above is the content of "what is the character set used in exp export files". After the study of this article, I believe you have a deeper understanding of what the character set used in exp export files is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.