*.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
精彩评论