To open .dmp file and copy into a database

[lane78]

Hi eveyone,

I'm very new to Oracle sql..this is my first attempt to work with Oracle.
There is a .dmp (dump file) in a server containing several tables, which in need to be transferred into a database. The database does not have a full set of required tables, this dump file will provide all the tables to complete the set.

My question is, how do i transfer the tables in dump file into the database and what is the syntax to perform this task. Pls help..

Thanks,
lane

 

[alexhu]

You need to use the import utility. There are very detailed instructions in the Utilities Manual

If you do not have the doc its available online at:

http://technet.oracle.com/docs/content.html

but only for Oracle 8 & 9

Alex

 

[nikhilwani]

Dear Friend
Please Let me know on Which Platform you are working and what is the Oracle Version.
Then i will reply to your answer beacause i am knowing for SCO Unix and DEC Alpha Unix for Oracle.

Regards
Nikhil Wani
Vadodara

 

[lane78]

Hi all,

Thanks for your tips and advice.
I've figured out how to transfer the dump files..

>imp userid=<username>/<password> file=<dmp filename> ignore=Y fromuser=<source> touser=<destination>

Regards,
lane