Oracle Data Pump Import and Export case

The Oracle Database Import and Export tool can use expimp, but this is an earlier tool. This document describes how to use the data pump expdpimpdp tool.

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.

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

Related reading:

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