Wednesday, February 24, 2010

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)

5 comments:

ramesh gollapally said...

Thanks for sharing fabulous information.It' s my pleasure to read it.I have also bookmarked you for checking out new posts.
Digital Marketing Training in Hyderabad


supraja k said...

Excellent information
Salesforce Training in Hyderabad

sss said...

Thanks for providing Import Oracle Database wih Data information.

Now a days big data is creating various opportunities.
salesforce online training

Lingam Kalyani said...

hii you are providing good information.Thanks for sharing if any one interested SAP APO

Online training see below

SAP APO Online

Lingam Kalyani said...

hii you are providing good information.Thanks for sharing if any one interested SAP APO
Online training see below

http://www.sapapoonlinetraining.in/