Data export, command exp, import data from a remote database locally, such as you can export data from a database in Linux to Windows local under Windows.
1 The database test is fully exported, the user Name System Password Manager is exported to D:\daochu.dmp, and all the data in the test database is exported to a DMP file. The prerequisite is that the login user, the system, has export permissions.
Exp System/manager@test file=d:\daochu.dmp full=y
2 Export the tables of the system user in the database and the SYS user's table, specifying that some users will be exported.
Exp system/manager@test file=d:\daochu.dmp owner= (System,sys)
3 Export the tables in the database table1, table2, and specify to export the pinned tables
Exp system/[email protected] file=d:\daochu.dmp tables= (table1,table2)
Data import, Command imp
1 Import the data from the D:\DAOCHU.DMP into the test database. To delete the table that will be imported, if it is a full library import, delete all the tables, or the import process will report the error.
Imp system/[email protected] file=d:\daochu.dmp
2 Import the table Table1 in the d:\daochu.dmp, this is the data that specifies the import fixed one table.
Imp system/[email protected] file=d:\daochu.dmp tables= (table1)
Oracle data Import, export DMP file