Oracle 11g command Import and Export table

Data export:

1 The database test is fully exported, user Name System Password Manager exported to D:\daochu.dmp exp System/[email protected] File=d:\daochu.dmp

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

3 Exporting Tables Table1, table2 in the database

EXP System/[email protected] file=d:\daochu.dmp tables= (table1,table2)

4 Export the field in table Table1 in the database filed1 the data beginning with "00" exp system/[email protected] file=d:\daochu.dmp tables= (table1query=\ "where Filed1 like ' 0% ' \ "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 full=y

2 imp system/[email protected] full=y file= d:\data\newsmgnt.dmp 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.

3 Import the table table1 in D:\daochu.dmp

Oracle 11g command Import and Export table