Link to home
Start Free TrialLog in
Avatar of ob1_
ob1_

asked on

How do you restore an Oracle DB from a .dmp file?

I have a DMP file from an Oracle database. It is version 10g1.

I've just installed Oracle 10g2 Express Edition (I couldnt find 10g1 on the Oracle website).

Can I restore this 10g1 DMP file to 10g2 Express Edition?

How do I restore the database?


Thanks,
ob1

ASKER CERTIFIED SOLUTION
Avatar of Muhammad Ahmad Imran
Muhammad Ahmad Imran
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ob1_
ob1_

ASKER

ok thanks - i am getting prompted for usrname/pw. should i use the system account i specified the pw for during Oracle setup? what is the username for this? if not how do i create a user?
Avatar of ob1_

ASKER

nevermind i was typing the wrong password.

i accepted all the defaults and it says "FromUser 'System' not found in export file. Import terminated successfully with warnings".

is that  normal?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ob1_

ASKER

i am not sure - it was exported from another system i don't have access to. as long as i can get to the data i don't care if the usernames are the same.

is there a way for me to see the database in Oracle now that i have imported it?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ob1_

ASKER

if i run "imp system/password file=filenaem.dmp show=y" i get "unknow command beginning 'imp system...' - rest of line ignored
Avatar of ob1_

ASKER

it says "Warning: the objects were exported by SAMPLE, not by you"

i am trying to create a user for SAMPLE in Oracle so I can specify touser=SAMPLE but when I try to run this command all I get back is a new line that says "2".

 
create user SAMPLE identified by password
Avatar of ob1_

ASKER

ok now i have entered "create user SAMPLE identified by password;" with the semicolon and it comes back with "SP2 - 0640" - any help??
Are you now able to run the imp command?
Try this:

imp system/password file=filename fromuser=sample touser=sample
Avatar of ob1_

ASKER

used partial answers to resolve question