Oracle Database Import and Export

The following is an example of importing and exporting, and seeing an instance of import and export is basically done, because importing and exporting is simple.
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 full=y 2 data  Table export of System user and SYS user in library exp system/[email protected] file=d:\daochu.dmp owner= (system,sys) 3 Export the table table1, table2 in the database exp System/[email protected] file=d:\daochu.dmp tables= (table1,table2) 4 Export the fields in the table table1 in the database filed1 the data beginning with "00" Exp system/[ Email protected] file=d:\daochu.dmp tables= (table1) query=\ "where filed1 like ' 0% ' \" Above is a common export, for compression I don't care much, with WinZip                     The DMP file can be very well compressed.   But with Compress=y on the back of the command, you can import the data 1 import the data from the D:\DAOCHU.DMP into the test database.   Imp System/[email protected] file=d:\daochu.dmp above may be a problem, because some tables already exist, and then it is an error, the table will not be imported. 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 I have completely removed the table and then imported it.
Note: You need to have sufficient permissions to have enough permissions and it will prompt you. Database, you can connect to the. You can use tnsping test to get the database test to connect. Data export: Exp hkb/[email protected]_14 full=y file=c:\orabackup\hkbfull.dmp log=c:\orabackup\hkbfull.log; Export considerations: Export the current user's data, if the current user has DBA authority, then export all the data! Data import between users with the same name: Imp hkb/[email protected] file=c:\orabackup\hkbfull.dmp log=c:\orabackup\hkbimp.log full= Y data import between different names: Imp system/[email protected] fromuser=hkb touser=hkb_new file=c:\orabackup\hkbfull.dmp log=c:\orabackup\ Hkbimp.log;