Oracle Import and Export

The following is an example of importing and exporting.
Data export:
1 full export of database test, user Name System Password Manager exported to D:\daochu.dmp
Exp system/[email protected] file=d:\daochu.dmp full=y

2 Exporting the system user in the database to the SYS user's table
Exp system/[email protected] file=d:\daochu.dmp owner= (System,sys)

3 Exporting Tables Inner_notify, Notify_staff_relat in the database
Exp aichannel/[email protected] file= d:\data\newsmgnt.dmp tables=

(Inner_notify,notify_staff_relat)

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.
Import of data
1 Import the data from the D:\DAOCHU.DMP into the test database.
Imp system/[email protected] file=d:\daochu.dmp
Imp aichannel/[email protected] full=y file=file= d:\data\newsmgnt.dmp

Ignore=y
There may be a problem, because some tables already exist, and then it will error, the table will not be guided

Into.
Add Ignore=y to the back.

2 Import the table table1 in D:\daochu.dmp
Imp system/[email protected] file=d:\daochu.dmp tables= (table1)

Basically, the above import and export is enough. In many cases, you must first delete the table and then import it.

Oracle Import and Export