*********** Importing (exporting) data with tools
Tool (T)-"Export Table" (X)
Tool (T)-"Export Table" (X)
Selected Execution File location:
E:\oracle\product\10.2.0\db_1\bin\imp.exe (Exp.exe)
********* command Import and Export
Oracle Import DMP File command:
(1) Data Import database in DMP file
1. First go to cmd command window
2. Execute command: Imp userid= user name/password @ database name File=d:\daochu.dmp full=y ignore=y
File: Is the full path of the DMP file you are importing.
Full=y whether all imports are available only when the current user is a DBA.
Existing tables, the import will be error, the table will not be imported, after adding ignore=y on it.
(2) Import the table usertable in DMP
IMP User name/password @ database name File=d:\daochu.dmp tables= (usertable)
Oracle Export DMP File command:
(1) All data export
EXP User name/password @ database name File=d:\daochu.dmp full=y
(2) Export the table
EXP username/Password @ database name File=d:\daochu.dmp tables= (table1,table2)
(3) Export the ID field in the Table1 table starting with "0000"
EXP username/Password @ database name File=d:\daochu.dmp tables= (table1) query=/"where ID like ' 0% '/"
Oracle Database Import and Export
