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: