我从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