Oracle Data Import Export IMP / EXP
Function: Oracle Data Import Export IMP / EXP is quite with Oracle data restore and backup. Most of the cases can be imported with Oracle data into backups and restores (not lost data). Oracle has a benefit, although your computer is not a server, but you have installed an Oracle client and established a connection (through Net8 Assistant -> service naming to add the correct service naming you can think of a client and server End repair the road, then the data can be pulled out) so you can export data to the local, although it is far from you. You can also import DMP files into the far database server from locally. With this feature that you can build two identical databases, one for testing, one is used to formally use. Execution Environment: You can execute in SQLPlus.exe or DOS (command line), during DOS can be executed in Oracle 8i to install directory / ORA81 / BIN is set to global path, this directory is exp.exe and Imp.exe Documents are used to perform import exports. Oracle is written with Java, I want sqlplus.exe, exp.exe, Imp.exe these two files are packaged after being packaged. SQLPlus.exe calls exp .exe, Imp.exe, the class they parked, complete the import guides. The following describes an example of importing exports. It is basically completed to the imported export to see the instance because the import export is simple. Data Export: 1 Export Database Test, User Name System Password Manager Export to D: /Daochu.dmp in D: /Daochu.dmp File = D: /Daochu.dmp Full = Y 2 Put the database in the database with SYSTEM users with SYS users Table Export Exp System / Manager @ test file = d: /daochu.dmp Owner = (system, sys) 3 Export table table1, table2 in the database Exp System / Manager @ Test file = d: /daochu.dmp tables = (Table1, Table2) 4 Export Filed1 in the table table1 in the database exports exp system / manager @ test file = d: /daochu.dmp tables = D: /DAOCHU.DMP TABLES = (table1) query = / "Where filed1 like The top of '00% '/ "is a commonly used export. For compression, I don't care, using WinZip to compress the DMP file well. However, after the above command, add compress = y.
