Import and Export Oracle databases using exp/imp

Before using exp/imp to import and export data starting with exp/imp, pay attention to the following points: 1) This section uses Oracle 10g as an example. 2) exp. imp is the next executable file in the operating system and is stored in the/ORACLE_HOME/bin directory. So execute the command in cmd command mode. (You do not need to connect to sqlplus first) 3) exp. Do not add ";" after the imp command line. Otherwise, an error similar to the following will be reported: About to export specified users... EXP-00010: dbuser; is not a valid usernameExport terminated successfully with warnings. 1. exports the table of the specified user. instance: [SQL] exp system/password @ orcl file = d: \ dbuser. dmp owner = dbuser www.2cto.com 2. import the specified user's table imp system/password @ orcl file = d: \ work \ bak \ dbuser. dmp fromuser = dbuser full = y ignore = y if the imported db does not have the corresponding user and tablespace, you must first create: [SQL] create USER dbuserIdentified by password DEFAULT TABLESPACE "DBUSERSPACE" ACCOUNT UNLOCK; create tablespace DBUSERSPACE datafile 'd: \ oracle \ product \ 10.2.0 \ db_1 \ dbs \ DBUSERSPACE. DBF 'size 30 m autoextend on next 10 m maxsize 100 m extent management local; Author: oscar999