trying to restore database from .dmp file.

[wvdba]

hi.
i have obtained a .dmp file from a production database. i have been asked to delete the test database and make the test database look like the production database. so, i'm guessing a reload/restore of some sort is required. is there any way somone can guide me in the right direction as to what needs to be done to load this data into the test environment, please.
thanks.

 

[Turkbear]

Hi,
was the .dmp file created by an Oracle Export process?
Is it just data or a full database export?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[wvdba]

turkbear, thanks for reply.
it was created by oracle export process as below:
set oracle_sid=xxxxx
exp proddb/password buffer=320000 log=d:\exp.log owner=db_owner file=d:\xxxxx_09212010.dmp full=n consistent=y

 

[Turkbear]

Hi,
log into the test database ( or create a new instance of it) and import the data using the Oracle import command

imp testdb/password buffer=320000 from=db_owner to=YOUR TARGET SCHEMA file=d:\xxxxx_09212010.dmp



To Paraphrase:"The Help you get is proportional to the Help you give.."