查看dmp文件的字符集
<span class="Apple-style-span" style="color: rgb(51, 51, 51); line-height: 24px; background-color: rgb(255, 255, 255); "><font class="Apple-style-span" size="2" face="Arial"><p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; text-indent: 0px; ">1. 查看dmp文件的第2，第3字节 </p><p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; text-indent: 0px; ">cat 'dmp文件名' |od -x|head -1|awk '{print $2 $3}'|cut -c 3-6</p><p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; text-indent: 0px; ">如：0345</p><p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; text-indent: 0px; ">2. 然后用以下SQL查出它对应的字符集:</p></font></span><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Arial; line-height: 24px; background-color: rgb(255, 255, 255); font-size: small; "> SQL> select nls_charset_name(to_number('0354','xxxx')) from dual;</span><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Arial; line-height: 24px; background-color: rgb(255, 255, 255); font-size: small; "><br></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Arial; line-height: 24px; background-color: rgb(255, 255, 255); font-size: small; "> ZHS16GBK</span><span class="Apple-style-span" style="color: rgb(51, 51, 51); line-height: 24px; background-color: rgb(255, 255, 255); "><font class="Apple-style-span" size="2" face="Arial"></font></span></div>
页:
[1]