Oracle Database Import and Export commands

Import and Export commands IMP and EMP

1. Export the database test completely, and the username System Password Manager is exported to D: \ daochu. dmp.

Exp system/manager @ test file = D: \ daochu. dmp full = y

2. Export the tables of system users and SYS users in the database

Exp system/manager @ test file = D: \ daochu. dmp owner = (system, sys)

3. Export tables Table1 and Table2 in the database

Exp system/manager @ test file = D: \ daochu. dmp tables = (Table1, table2)

4. Export the data with the field filed1 in table 1 in the database starting with "00"

Exp system/manager @ test file = D: \ daochu. dmp tables = (Table1) query = \ "where filed1 like '201312 '\"

The above is a commonly used export. I am not very concerned about compression. I can use WinZip to compress the DMP file.

However, add compress = Y to the command above.

Data Import

1. import data from D: \ daochu. dmp to the test database.

IMP system/manager @ test file = D: \ daochu. dmp

The above may be a problem, because some tables already exist, and then it will report an error, the table will not be imported.

Add ignore = Y to the end.

2. Import table 1 in D: \ daochu. dmp

IMP system/manager @ test file = D: \ daochu. dmp tables = (Table1)