Use of oracle exp and imp commands

Oracle exp and imp commands are usually used to import and export ORACLE data. Before expdb and impdb (before 10 Gb), we use exp to export data, imp command. Open the CMD window and implement IMP. EXP is mainly completed by calling IMP. EXE and EXP. EXE in SQLPLUS. EXE. The following are some common examples of exp and imp commands. 1. Completely export exp system/oracle @ tnsname file = D: \ file. dump full = y can basically export all objects in the database, but some permissions cannot be exported. 2. Export exp system/oracle @ tnsname file = D :\\ file from the specified table. dump tables = tablename1, tablename2... www.2cto.com 3 export the specified data in the table to exp system/oracle @ tnsname file = d: \ file. dmp tables = table1 query = "where filed1 like '000000'" 4 data import 1) Import file. data in dump is imported into the test database. Imp system/manager @ test file = d: \ file. dmp is added with the ignore = y parameter. If some tables already exist, this table will not be imported. Add ignore = y to the end. 2) import the table specified in Table d: daochu. dmp to imp system/manager @ test file = d: \ file. dmp tables = chen1__1984 by table1.