ASP ScriptingJava ScriptingCGI ScriptingHTMLJavaLanguage CERP Education Links

Oracle Database Import / Export Help

1. How to use Oracle Database Import / Export Command Utility ?
   
   Exporting Database to File
   EXP80 username/password FILE=filepath FULL=y  [ or OWNER=ownername ]
   COMPRESS=y BUFFER=100000
   
   Importing from File to Database
   IMP80 username/password FILE=filepath FULL=y  [ or OWNER=ownername ]
   COMPRESS=y BUFFER=100000
   
   Hint : filepath : whole path where you want to save your file.
            compress : to save  file in compress mode.
            buffer : a bytes buffer used when transferring data from file to database and
                         vice-versa.
   
   Oralce Enterprise Tool Username and Password
   • Scott   ---> tiger
   • Admin ---> instance
   • Internal -> oracle
   • system --> change_on_install