Wednesday, February 17, 2010

How to export Oracle Database with data

There are more ways exporting the database but i feel the procedure i fallow is good for me. You can do this as simple steps.

Step 1 : Connect to the user sys as sysdba 
              d:\>sqlplus sys/syspassword as sysdba

Step 2: Select the user language from dual
              sql> select userenv('language') from dual;

Step 3:  Come out of the sqlplus and set the LNS_LANG from the command prompt
             set NLS_LANG=  paste above display language

Step 4: Import the user using the fallowing command
           exp file=dumpfilename.dmp owner=scott log=expample.log

Popular Oracle  Books From Amazon:

Expert Oracle Database 11g Administration (Expert's Voice in Oracle)Oracle Essentials: Oracle Database 11gBeginning Oracle Database 11g Administration: From Novice to Professional (Beginning from Novice to Professional)Oracle Database 11g The Complete Reference (Osborne ORACLE Press Series)

No comments: