开发者

how to import oracle dump file to oracle db?

I have customer oracle dump file, I used the following command to import this file to oracle db:

imp  user1/tartan@app92g fromuser=SYS touser=user1_1 file=PRD_10_06_11.dmp log=app_log1.log

Bu开发者_运维问答t it occurs the following error:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

So I am thinking it is not exported by oracle common imp/exp process, it should be exported by pump, Is anybody have idea what command I can use?


Try using impdp.

The best thing to do is to ask your customer how he produced this dump though.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜