Oracle Data Pump Import and Export case

The Oracle Database Import and Export tool can use exp/imp, but this is an earlier tool. This document describes how to use the data pump expdp/impdp tool.

Create a Data Pump directory

To use the data pump, you must first create a directory

Create directory dump_scott as '/home/oracle/dump/scott'

View the Created directory

Select * from dba_directories

Empower

Grant read, write on directory dump_scott toscott

 

Export Case 1: export by table

Expdp scott/tiger directory = dump_scottdumpfile = tab. dmp logfile = scott. log tables = dept, emp

 

Export case 2 by user

Expdp scott/tiger directory = dump_scottdumpfile = dumpscott. dmp schemas = scott

 

Export Case 3: Full Database Export and parallel export

Expdp scott/tiger directory = dump_scottdumpfile = full. dmp parallel = 4 full = y

 

Import Case 1: import by table, from scott to scott2

Impdp scott2/tiger directory = dump_scottdumpfile = tab. dmp tables = scott. dept, scott. emp remap_schema = scott: scott2

 

Import case 2 by user, from scott to scott2

Impdp scott/tiger directory = dump_scottdumpfile = schema. dmp remap_schema = scott: scott2

 

Import Case 3: Full Database Import

Impdp scott/tiger directory = dump_scottdumpfile = full. dmp full = y

 

Import case 4: Create a db link

Impdp scott/tiger directory = dump_scott network_link = remote_link remap_schema = scott: scott2

GoldenGate performs two-way Oracle-Oracle replication without using a Data Pump

One-way Oracle-Oracle Replication Using the GoldenGate Data Pump

How to debug Oracle Data Pump (expdp/impdp)

Oracle Database Export data pump (EXPDP) file storage location

Export of Oracle 10g Data Pump Partition Table