Oracle 11g Express版中的数据导入问题 [英] Data import problem in oracle 11g express edition
本文介绍了Oracle 11g Express版中的数据导入问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我已经使用以下命令将数据导入到从oracle 9i导出的oracle 11g express中.
I have use following commands for import data in to oracle 11g express which is exported from oracle 9i
impdp BANKUSER/BANKUSER directory=KUMARS dumpfile=12345G2.dmp FULL='Y'
但是它给出了以下错误
But it gives following error
ORA 39001:INVALID ARGUMENT VALUE
ORA 39000: BAD DUMP FILE SPESIFICATION
ORA 39143:DUMP FILE C:\KUMARS\12345G2.dmp MAY BE AN ORIGINAL DUMP FILE
请给我任何解决方案!!!!!!!!!!!!!!!!!!!!!
[edit]已删除呼喊"-OriginalGriff [/edit]
Please give any solution to me!!!!!!!!!!!!!!!!!!
[edit]SHOUTING removed - OriginalGriff[/edit]
推荐答案
AFAIKexpdp
在9i中不存在,因此无法直接将其导入11g.如果在9i中使用exp
,则在11g中使用imp
导入数据.
AFAIKexpdp
does not exist for 9i so you cannot directly import it in 11g. If you have usedexp
in 9i then useimp
in 11g to import the data.
这篇关于Oracle 11g Express版中的数据导入问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文