oracle@DBserver:~/bms> ls T_MCHNT_APP_YSPRO.dmp T_MERCHANT_YSPRO.dmp oracle@DBserver:~/bms> imp bms/bms file=./T_MCHNT_APP_YSPRO.dmp ignore=y fromuser=um_bms touser=bmsImport: Release 11.2.0.1.0 - Production on Thu Jul 5 14:21:57 2012Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport file created by EXPORT:V10.02.01 via conventional pathWarning: the objects were exported by UM_BMS, not by youimport done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) export client uses ZHS16GBK character set (possible charset conversion) Import terminated successfully without warnings.照你说的做了,出这些信息,在bms库里,还是原来那些表,为什么?
我加了statistics=none试了一下,还是一样的问题
我想把当前linux bms目录下的这两个bms文件,导入到服务器上的oracle中,就是出这个错误,路径什么的没错吧?
http://img.my.csdn.net/uploads/201207/04/1341399962_5893.jpg
fromuser=um_bms touser=bms_new
T_MCHNT_APP_YSPRO.dmp T_MERCHANT_YSPRO.dmp
oracle@DBserver:~/bms> imp bms/bms file=./T_MCHNT_APP_YSPRO.dmp ignore=y fromuser=um_bms touser=bmsImport: Release 11.2.0.1.0 - Production on Thu Jul 5 14:21:57 2012Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport file created by EXPORT:V10.02.01 via conventional pathWarning: the objects were exported by UM_BMS, not by youimport done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
Import terminated successfully without warnings.照你说的做了,出这些信息,在bms库里,还是原来那些表,为什么?
imp bms/bms file=./T_MCHNT_APP_YSPRO.dmp ignore=y fromuser=datacenter touser=bms
但我还是不明白,为什么改成fromuser = datacenter就能导入成功尼????