Export of data:
1, the database Szda fully exported, the user name sa password sa123 exported to D:\daochu.dmp
Exp Sa/[email protected] file=d:\daochu.dmp full=y
2. Export the SA user in the database with the SYS user's table
Exp Sa/[email protected] file=d:\daochu.dmp owner= (Sa,sys)
3. Export the table table_1 and table_2 in the database
Exp Sa/[email protected] file= d:\daochu.dmp tables= (table_1,table_2)
4. Export the field filed1 in table Table_1 in the database with the data beginning with "00"
Exp Sa/[email protected] file=d:\daochu.dmp tables= (table_1) query=\ "where filed1 like ' 0% ' \
Import of data:
1. Import the data from the D:\DAOCHU.DMP into the Szda database.
Imp Sa/[email protected] File=d:\daochu.dmp
Imp sa/[email protected] full=y file=file= d:\daochu.dmp ignore=y
The above may be a problem, because some tables already exist, and then it will be an error, the table will not be imported, add Ignore=y on the back.
2. Import the table Table_1 in D:\daochu.dmp
Imp sa/[email protected] file=d:\daochu.dmp tables= (table_1)
Import and export DMP database files in Oracle