CODEWITHSUNDEEP
oracle-databaseimportschema
Vladimir
Vladimir

Reputation: 13153

*.dmp file import in Oracle

I need to import data from *.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?

Upvotes: 1

Views: 2035

Answers (1)

Khb
Khb

Reputation: 1433

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

Upvotes: 1

Related Questions