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
Expsystem/[email protected]=d:\daochu.dmpowner= (System,sys)
3 Exporting Tables Table1, table2 in the database
Expsystem/[email protected]=d:\daochu.dmptables= (Table1,table2)
4 Export the field filed1 in table table1 in the database with data beginning with "00"
Expsystem/[email protected]=d:\daochu.dmptables= (table1) query=\ "wherefiled1like ' 0% ' \"
The above is a common export, for compression I do not care, with WinZip to the DMP file can be very good compression.
But add compress=y to the upper order.
Import of data
1 Import the data from the D:\DAOCHU.DMP into the test database.
Impsystem/[email protected]=d:\daochu.dmp
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.
2 Import the table table1 in D:\daochu.dmp
Impsystem/[email protected]=d:\daochu.dmptables= (table1)
Note: Users who export the DMP data need to have permission to export the table, otherwise they cannot export.
Oracle data Backup and restore (import and export) cmd command