开发者

*.dmp file import in Oracle

开发者 https://www.devze.com 2022-12-10 14:37 出处:网络
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

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

精彩评论

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