how to import .dmp file into oracle database

hi,

First copy that file into C:\ or d:\ to avoid confusion with path names.

go to sqlplus

create a user into which the file needs to be imported. if he is other than dba then dba grants needs to be assigned to him to import the .dmp file.

then open cmd

write below command.

imp databaseusername/password file=E:\filename.dmp full=yes

thats it !!!!!