Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Total Newbie here. How to import .dmp.

900824Nov 17 2011 — edited Nov 17 2011

I am completely new to Oracle Databases. The only thing I have used in the past is access. I have been given a Oracle Database .dmp file that I need to import into a database to see what is in it. I have installed Oracle Database 11g Express Edition and Oracle SQL Developer. I have read some things about the imp and impdp commands but I don't know how to use them correctly. My questions are:

Where should I put the .dmp file so that the database can see it?

What command should I give at the SQL> prompt? I have tried impdp user/password file=NH0339016.dmp This didn't work.. I got the error "unknown command beginning "impdp user..." - reset"

After importing it, how do I see what is in the database?

I'm really struggling with this thing and I would appreciate any help that I can get.

Thanks

Will