Import and export of a single data table in oracle 10 GB 1. Export tool exp is an executable file in the bin folder under the oracle root directory. The specific directory is/ORACLE_HOME/BIN/exp. This tool can be used to export tables in the database. The interactive procedure is as follows: 1. Start --> program --> Oracle DataBase 10g Express Edition --> Start the DataBase. After the execution, the path is automatically changed to the bin directory. 2. Enter exp, press enter, and then enter as prompted, as shown below: D: \ Program \ oracle \ app \ oracle \ product \ 10.2.0 \ server \ BIN> net start OracleXETNSListener request service has been started. Type net helpmsg 2182 for more help. D: \ Program \ oracle \ app \ oracle \ product \ 10.2.0 \ server \ BIN> net start OracleServiceXE request service has been started. Type net helpmsg 2182 for more help. Note: Start the interactive operation. D: \ Program \ oracle \ app \ oracle \ product \ 10.2.0 \ server \ BIN> expExport: release 10.2.0.1.0-Production on Sunday December 21 20:13:24 2008 Copyright (c) 1982,200 5, Oracle. all rights reserved. username: <enter username, press enter> password: <enter password, press enter> connect to: Oracle Database 10g Express Edition Release 10.2.0.1.0-Production input array extract buffer size: 4096> press enter to export the file: EXPDAT. DMP> is the File Export command. The default value is EXPDAT. DMP, press enter (2) U (user), or (3) T (table): (2) U> 3 Press enter to export table data (yes/no ): Yes> press ENTER Compression Area (yes/no): yes> press enter to export the ZHS16GBK Character Set and AL16UTF16 NCHAR Character Set server to use the AL32UTF8 character set (possible Character Set conversion) to export the specified table, use the regular path... the table (T) or partition (T: P) to be exported: (exit by RETURN)> employee (employee) is the specific table name in the database .. exporting table EMPLOYEE export 4 rows of EXP-00091: Exporting problematic statistics. To export the table (T) or partition (T: P): (Press RETURN to exit)> press enter to complete the preceding operations, you can go to the bin directory, find the exported file. If no file name is specified, it is EXPDAT. DMP. 2. The import tool imp is an executable file in the bin folder under the oracle root directory. The specific directory is/ORACLE_HOME/BIN/imp. The use of imp is basically the same as that of exp. Follow the prompts to complete the operation.