Database dump Import

database dump import

Introduction of the Import command:

There are two ways to import and export Oracle dump data:imp/exp,impdp/expdp. The difference between the two:

1, exp/imp client program, affected by the network, disk, IMPDP/EXPDP server-side programs, only affected by the disk .

2.exp Conventional Way is to useSELECTthe way to query the data in the database is throughBuffer Cacheand througheverSqlThe statement processing layer is then transferred toExpthe Export file. The flow of data for this process is: (1) data throughSelectthe data is loaded by the file system into theBuffer Cache(Database Cache) (2) byPGA(user process, each connection will correspond to aPGA) transfers the cached data over the network to the client-generated file. EXP Direct path mode ,The number is directly from the disktransferred toExpexport files, so faster. andEXPDPis aExpthe upgraded version, the files are compressed and processed in parallel, so the speed is the fastest.

Second, the data import step

1. Create User

Create user Res_xj identified by q1w2e3r$ default Tablespace general;

Grant DBA to RES_XJ;

2. CREATE TABLE Space

Create Tablespace Indx_gen

DataFile ' E:\oradata\resdb\INDX_GEN01.dbf ' size 5000M

Autoextend on

Next 5000M

MaxSize 30000M

Extent management Local;

3. Building Files Directory
Create or replace directory Dump_dir as ' H:\cq_resdata_dump ';

4. Import Statements

IMPDP res_xj/q1w2e3r$ directory=dump_dir dumpfile=expdp_20161014_xj.dmp logfile=imp_20161108.log FULL=Y TABLE_EXISTS _action=replace

Specific parameters, please search the Internet.

Third, the matters needing attention

1. Note the size of the table space.

2. When importing, note the exported database and the version of the imported database.

3, if the first import has a problem, terminated the import, the second import please add table_exists_action=replace, otherwise the database already exists object, this import will be ignored. Data that is not finished will also be ignored.

Database dump Import