Oracle Database Import and Export

2. Data export
   

   ① to fully export the database ORCL

   Exp Lims/[email protected] file=d:lims_20150104.dmp full=y

   ② exporting LIMs users in a database

   Exp Lims/[email protected] file=d:daochu.dmp owner= (LIMS)

   ③ to export tables in the database

   Exp Lims/[email protected] file=d:daochu.dmp tables= (test,result)

   ④ Export the results of queries in the database

   Exp Lims/[email protected] file=d:daochu.dmp tables= (sample) query= "Where description like '%a% '"

   The above is commonly used for the export, for compression, both with WinZip to the DMP file can be very good compression.
   It can also be implemented by adding compress=y to the above command.
   

4. Data export

   ① to import d:daochu.dmp data into the database

   Imp Lims/[email protected] File=d:daochu.dmp

   Imp lims/[email protected] file=d:daochu.dmp full=y ignore=y

   There may be a problem, because some tables already exist, and then it is an error, and the table is not imported.
   Add Ignore=y to the back.

   ② Import d:daochu.dmp Table table1

   Imp lims/[email protected] file=d:daochu.dmp tables= (table1)

   
   

Oracle Database Import and Export