一台windows2008 64位,安装了64位的oracle11g,一台window2003 32位 安装了 32位的oracle 11g
我现在想把64位的oracle11g的数据导出到32位上面
我先在Oracle11g机器上面用
exp risenetzx/risenetzx@ORCLA file=D:\DBbackupjg.dmp log=D:\db_exp.log owner=risenetzx rows=n 把表结构导出,数据导出成功
然后再32位上面用
imp RISENETZX/1@orcl file=E:\DBbackupjg.dmp log=E:\db_expjg.log full=y 导入报错
我现在想把64位的oracle11g的数据导出到32位上面
我先在Oracle11g机器上面用
exp risenetzx/risenetzx@ORCLA file=D:\DBbackupjg.dmp log=D:\db_exp.log owner=risenetzx rows=n 把表结构导出,数据导出成功
然后再32位上面用
imp RISENETZX/1@orcl file=E:\DBbackupjg.dmp log=E:\db_expjg.log full=y 导入报错
连接到: Oracle Database 11g Release 11.1.0.7.0 - Production经由常规路径由 EXPORT:V11.02.00 创建的导出文件
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
. 正在将 RISENETZX 的对象导入到 RISENETZX
IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '00320030003000395E7"
"45EA60020002088685F700020002051B35B9A'; SREC.MAXVAL := '98865BFC73ED5B50300"
"0516C63A83000901A77E5'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY"
"(utl_raw.cast_to_varchar2('00320030003000395E745EA60020002088685F7000200020"
"51B35B9A'),utl_raw.cast_to_varchar2('006E0075006C006C'),utl_raw.cast_to_var"
"char2('201C53414E8C4E94201D89C45212002000205DE54F5C65B9684800200020901A'),u"
"tl_raw.cast_to_varchar2('201C53414E8C4E94201D89C45212002000205EFA8A00732E7B"
"5600200020610F'),utl_raw.cast_to_varchar2('201C53414E8C4E94201D89C452120020"
"002098865BFC8BB28BDD00200020901A'),utl_raw.cast_to_varchar2('4E2D592E4F1A8B"
"AE002000205B664E6000200020901A77E5'),utl_raw.cast_to_varchar2('4E3B5E2D4F1A"
"8BAE002000207763529E63D0684800200020901A77E5'),utl_raw.cast_to_varchar2('4E"
"3B5E2D73ED5B50002000205DE54F5C52065DE500200020901A77E5'),utl_raw.cast_to_va"