开发者

*.dmp file import in Oracle

I need to import data from *开发者_JAVA百科.dmp file say mydump.dmp. What I'm doing is:

imp myuser/mypass file=mydump.dmp log=mylog.log

And I'm getting:

only a DBA can import a file exported by another DBA

I know the DBA credentianls to db but I want to import dump into 'myuser' schema. So how to do it?


imp system/xxx file=mydump.dmp log=mylog.log touser=destination_schema

You have to import as system, since it was exported as system

Regards

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜