oracle 同字节序跨平台,表空间跨平台传输异常（同字节序的）

我从windows xp系统上的oracle 10g表空间trans传输到RHEL 5.4平台，也是oracle 10g的，结果传输失败，不知何原因，报错如下：

[oracle@fox1 ~]$ imp \"sys\/oracle as sysdba\" tablespaces=trans transport_tablespace=y file=/share/exp_trans.dmp datafiles=/share/01_MF_TRANS.DBF

Import: Release 10.2.0.1.0 - Production on Mon Mar 7 14:29:22 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path

About to import transportable tablespace(s) metadata...

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses WE8ISO8859P1 character set (possible charset conversion)

export client uses ZHS16GBK character set (possible charset conversion)

. importing SYS's objects into SYS

. importing SYS's objects into SYS

IMP-00017: following statement failed with ORACLE error 29345:

"BEGIN   sys.dbms_plugts.beginImport ('10.2.0.1.0',852,'2000',7,'Microsoft W"

"indows IA (32-bit)',51266,81351,1,0,0,0); END;"

IMP-00003: ORACLE error 29345 encountered

ORA-29345: cannot plug a tablespace into a database using an incompatible character set

ORA-06512: at "SYS.DBMS_PLUGTS", line 2386

ORA-06512: at "SYS.DBMS_PLUGTS", line 1946

ORA-06512: at line 1

IMP-00000: Import terminated unsuccessfully

在线等

纠结很久了

作者: yeluyide

发布时间: 2011-03-07