Import and export of data (backup and restore)

Imp/exp They are the next executable file store directory in the operating system/oracle_home/bin

This command executes in Start menu >> run >>cmd (shortcut key: Windows+r input CMD)

Data Export (Exp.exe)

1, the database ORCL completely exported, user name System, password ACCP, exported to d:\daochu.dmp file

Exp SYSTEM/ACCP@ORCL file=d:\daochu.dmp full=y

2, the database ORCL in the Scott user's object export

Exp SCOTT/ACCP@ORCL file=d:\daochu.dmp Owner=scott

3, the database ORCL the Scott User's Table EMP, dept Export

Exp SCOTT/ACCP@ORCL file= d:\daochu.dmp tables=emp,dept Owner=scott

4, the database ORCL in the table space Testspace export

Exp SYSTEM/ACCP@ORCL file=d:\daochu.dmp Tablespaces=testspace

Second, data import (Imp.exe)

1. Import data from d:\daochu.dmp into ORCL database

Imp SYSTEM/ACCP@ORCL file=d:\daochu.dmp full=y

2, if the import, the data table already exists, will be an error, the table will not be imported, plus ignore=y, you can ignore existing tables, append records on existing tables

Imp SCOTT/ACCP@ORCL file=d:\daochu.dmp full=y ignore=y

3, the D:\DAOCHU.DMP in the table EMP Import

Imp SCOTT/ACCP@ORCL file=d:\daochu.dmp tables=emp

When you import data, you often take the buffer attribute buffer=8192000