现在看看你的这个数据库是什么字符集
用sys 用户登陆,然后执行下面的sql
select *from sys.props$ where name like 'NLS_CHARACTERSET';
select *from sys.props$ where name like 'NLS_NCHAR_CHARACTERSET';
看看你现在的字符集是什么。
如果和那台windowsXp上的Oracle9i的字符集不一致,建议你把那台linux的机上的
database drop 掉,重新建一个 database ,在重建database 时候可以设定字符集,最好要和那台windowsXp上的Oracle9i的字符集一致,或者设置成那台windowsXp上的Oracle9i的字符集的超集。
When export on WindowsXp is another machine info..:
exporting.. ZHS16CGB231280 characterset and AL16UTF16 NCHAR characterset.
Flowing is the import info on Linux box:
import done in US7ASCII character set and ZHS16GBK NCHAR character set
import server uses ZHS16CGB231280 character set (possible charset conversion)
export client uses ZHS16CGB231280 character set (possible charset conversion)
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)