Use the Oracle expdp/impdp Tool

Oracle Data Pump

I. Role of Data Pump:

1. implement logical backup and logical recovery

2. move objects between database users

3. move objects between databases

4. Implement table space Transfer

Ii. Differences between Data Pump Characteristics and traditional export and import

1. EXP and IMP are client-segment tool programs, and EXPDP and IMPDP are server-side tool programs.

2. EXP and IMP are less efficient. EXPDP and IMPDP are more efficient.

3. Powerful Data Pump functions in parallel, filtering, conversion, compression, encryption, and Interaction

4. Data Pump versions earlier than 9i are not supported, and EXP/IMP are applicable in the short term.

5. The same exp/imp data pump export includes four modes: export table, export scheme, export tablespace, and export database.

Iii. Architecture of data pump:

1 2 3 4 5 Next Page