How to Import Oracle Database wih Data

Step 1:  Move to dmp file directory using command prompt

Step 2:  Connect to dba user in oracle

            sqlplus sys/manager as sysdba

Step 3:  Select the user language from the dual

            select userenv('language') from dual

Step 4:  Create the user in database with username empuser and password userpassword
              (use your own user/password)

             create user empuser identified by userpassword

             grant connect,resource privileges to empuser

Step 5: Come out from the sqlplus

             exit;

Step 6: set the language of the user which you got in the Step 3 in the command prompt.

             set NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

Step 7: import the database

            imp file=empuser.dmp fromuser=scott touser=empuser log=temp.log commit=y


These are the basic steps which i fallow while importing. These are not enough some times while importing and you can use several other methods to import the database.  


The popular oracle Books from Amazon:


Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series) 
Guide to Oracle 10g 
Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press 
Oracle Database 10g PL/SQL ProgrammingSeries)