Common Oracle Import and Export commands

 Common Oracle Import and Export commands

 

Run this command in "Start Menu> RUN> cmd ".

One-stop data export (exp.exe)

1. Export the database orcl completely, username system, and password accp to the d: \ daochu. dmp file.
Exp system/ACCP @ orcl file = D: \ daochu. dmp full = y
 
2. Export Scott user objects in the database orcl
Exp Scott/ACCP @ orcl file = D: \ daochu. dmp owner = (Scott)
 
3. Export the table EMP and Dept of Scott in the database orcl.
Exp Scott/ACCP @ orcl file = D: \ daochu. dmp tables = (EMP, Dept)

 

4. Export the tablespace testspace in the database orcl
Exp system/ACCP @ orcl file = D: \ daochu. dmp tablespaces = (testspace)

 

Binary data import (imp.exe)

1. import data from D: \ daochu. dmp to the orcl database.
IMP system/ACCP @ orcl file = D: \ daochu. dmp full = y

 

2. If the data table already exists during import, an error will be reported and the table will not be imported. Add ignore = y to ignore the existing table and append records to the existing table.
IMP Scott/ACCP @ orcl file = D: \ daochu. dmp full = y ignore = y

 

3. Import the table EMP in D: \ daochu. dmp
IMP Scott/ACCP @ orcl file = D: \ daochu. dmp tables = (EMP)