oracle us7ascii 中文,如何将中文字符集的数据导入US7ASCII

手工修改DMP文件然后在作imp试试。

给你个例子参考,Good Luck

When investigating problems like these it is useful to check the character set used for the export. As said above, this is held in the export dump file. It can be seen by doing a hex dump of the export file as follows (in Unix):

cat expdat.dmp | od -x | head

This will produce output similar to:

0000000 0300 0145 5850 4f52 543a 5630 372e 3033

0000020 2e30 330a 4454 534f 0a52 5441 424c 4553

0000040 0a31 3032 340a 300a 0020 2020 2020 2020

0000060 2020 2020 2020 2020 2020 2020 2020 2020

*

0000140 2020 2020 2020 2020 4d6f 6e20 4e6f 7620

0000160 3130 2031 343a 3031 3a33 3620 3139 3937

0000200 0a54 4142 4c45 2022 454d 5022 0a43 5245

0000220 4154 4520 5441 424c 4520 2245 4d50 2220

The second and the third byte in the file define the character set used for the export.

The 16-bit value is stored big-endian, i.e. the more significant byte first. On little-endian platforms, e.g. Sequent Dynix/PTX, the output will  be slightly different as below:

00000000 0003 4501 5058 524f 3a54 2e37 3330 etc.

In the example above, the second byte is 0x00 and the third byte is 0x01, yielding 0x0001 as the character set ID. This shows that NLS_LANG was set to US7ASCII during the export.

The new Oracle8 functions NLS_CHARSET_NAME and NLS_CHARSET_ID can be used to map character set IDs to character set names. The mapping is also given in .

The values for the most commonly used character sets are below:

Name            ID

----------------------

US7ASCII        0x0001

WE8DEC                0x0002

WE8ISO8859P1        0x001f

EE8ISO8859P2        0x0020

SE8ISO8859P3        0x0021

NE8ISO8850P4        0x0022

CL8ISO8859P5        0x0023

AR8ISO8859P6        0x0024

EL8ISO8859P7        0x0025

IW8ISO8859P8        0x0026

WE8ISO8859P9        0x0027

TH8TISASCII        0x0029

WE8ROMAN8        0x0005

WE8PC850        0x000a

US8PC437        0x0004

EE8PC852        0x0096

EE8MSWIN1250    0x00aa

CL8MSWIN1251    0x00ab

EL8MSWIN1253    0x00ae

WE8MSWIN1252    0x00b2

JA16EUC        0x033e

JA16SJIS        0x0340

ZHT16BIG5        0x0361

In this example i have changed the export file's charset from US7ASCII to WE8ISO8859P1.

D:\>debug D:\expdat.dmp

-d

1481:0100  03 00 01  ... ...EXPORT:V08.00

1481:0110  2E 30 ...

(now change the third byte)

-e 1481:0100 03 00 1F ...

-w

-q