Introduction to ORACLE.DMP file import and data pump (database Dump) technology ____oracle

about whether to import with imp command, or import with IMPDP command, you'd better ask if the traditional exp generated DMP file or DataPump generated DMP file, the former to be imported with IMP, the latter with IMPDP import.

Second, the characteristics of data pump and the difference between the traditional export import

1.EXP and Imp are Oracle Customer segment tool programs, EXPDP and IMPDP are service-side tools

2.EXP and IMP are less efficient. High efficiency of EXPDP and IMPDP

3. Data pump features powerful parallel, filtering, conversion, compression, encryption, interaction, etc.

4. Data pump does not support the previous version of 9i, exp/imp in the short term or more applicable

5. With EXP/IMP data pump export includes export table, export scheme, export table space, export database 4 ways.///////////////////////////////////////////////////

I. EXPDP and IMPDP use instructions

Oracle database 10g introduces the latest data pump (database Dump) technology, the role of data Pump export import (EXPDP and IMPDP)

1 Implement logical backup and logical recovery.

2 Move objects between database users.

3 Moving objects between databases

4) To implement the table space removal.

Two, data pump export import and traditional export import difference

Prior to 10g, traditional export and import using exp tools and IMP tools, starting from 10g, not only retained the original exp and IMP tools, but also provided data pump export Import Tools EXPDP and IMPDP. What you should be aware of when using EXPDP and IMPDP:

1 exp and IMP are client-side utility programs that can be used either on the client or on the server.

2 EXPDP and IMPDP are service-side tools that they can use only on the Oracle server and not on the client side.

3 IMP applies only to the EXP export file, not to the EXPDP export file, IMPDP only applies to EXPDP export files, not to exp export files. Data pump export includes export table, export scheme, export table space, export database 4 ways.///////////////////////////////

Example: A statement that imports a. dmp file

IMPDP llms/llms dumpfile=llms.dmp remap_schema=llmsinit:llms remap_tablespace=ami_tj:llms EXCLUDE=STATISTICS