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