Oralce data export and import

There are many ways to export and import ORACLE data. You can simply record how to use commands.

Method 1. Use PLSQL to export and import data

In this way, you can export and import DMP files, SQL files, and data.

Method 2: Import and Export commands

Run the doscommand
Data Export:
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 System user and SYS user tables in the database
Exp system/manager @ test file = D: daochu. dmp owner = (system, sys)
3. Export the inner_noty and noty_staff_relat tables in the database.
Exp aichannel/aichannel @ testdb2 file = D: datasmgnt. dmp tables = (inner_noty, noty_staff_relat)
4. Export the field filed1 in table 1 in the database with the header "00"
Exp system/manager @ test file = D: daochu. dmp tables = (Table1) query = "where filed1 like '201312 '"
The above is a common export. For compression, the DMP file can be well compressed using WinZip.
You can also add compress = Y to the end of the preceding command.

Data Import:
1. import data from D: daochu. dmp to the test database.
IMP system/manager @ test file = D: daochu. dmp
IMP aichannel/aichannel @ HUST full = y file = D: datasmgnt. dmp ignore = y
The table already exists, and an error is reported. The table is not 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)