plz tell me ,how to import the dmp file located in the hard drive to the oracle ..
i have created the user and password, now i m trying to import it through
console, i m getting the following error..
Even i hav downloaded the dmp file again still error ..
wat i m getting the error is IMP-00010 error...
As Littlefoot said: IMP is not the right tool for this.
Use SQL*Loader (sqlldr) for this
How to use sqlldr is explained in the link he posted.
Or find a decent GUI front end, that will let you do that.
OK, forget my answer. I read dmp as bmp and thought you wanted to import a bitmap file into a column (because the subject reads 'bmp').
IMP is indeed the correct tool for a .dmp file
What is the format of the "dmp" file you have? Is it a text file (flat file), use sql*loader. An oracle export file, use IMP, an Oracle data pump file, use impdp. If you don't know, paste the first couple of lines into this forum.
You do not need a parachute to skydive. You only need a parachute to skydive twice.