Oracle Data Pump – Export Import ( Expdp Impdp ) Tutorial with Examples-1


In this article I will explain the data pump technology which we use frequently in Oracle databases. This technology is very often used by Oracle DBAs because it provides very effective Table and schema based backups which we cannot do with RMAN.

data pump


We use data pump technology to move data from a database to a different database. The data pump is also a nice technology in schema and table-based backup. The data pump is also a nice technology for schema and table-based backup.

Although the Oracle database backup tool is RMAN (Recovery Manager), RMAN may be inadequate in some issues. Oracle datapump helps in this case. We cannot do this with RMAN when we want to move a table or schema between 2 different databases, but we can do it with data pump.


With the data pump, only tables and schema can be moved in full database and tablespace. With the data pump technology, we can export the data from a database and import it into the other database. For this, Oracle offers expdp for export and impdp tool for import.


Data pump 2


I will now describe the use and examples of expdp and impdp commands below.


Expdp: You can take export of the table (s), schema (s) and tablespace (s) with this command. These export files are also used frequently in Backup solutions because they provide redundancy. A user must have EXP_FULL_DATABASE privileges to export the data related to this command.


IMPDP: You can import the table (s), schema (s) and tablespace (s)  to the target database with this command. A user must import IMP_FULL_DATABASE privileges to import export files with this command.

We can run these two commands on the operating system and perform the related operations. The data is taken from Export is kept with .dmp at the specified path. If you do not create a directory on the operating system for the data pump, the export files that are taken by default are discarded to the path under parameter of DATA_PUMP_DIR directory. We can create a separate directory for datapump on the operating system as follows.


create directory DATAPUMP as '/backup';

Related (sys,system) User has to have read / write permission on the related directory . We should grant read and write permission like following

grant read, write on directory DATAPUMP to sys;



Next article link is as follows.

Oracle Data Pump – Export Import ( Expdp Impdp ) Tutorial with Examples-2


Do you want to learn Oracle Database for Beginners, then read the following articles.

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.


  1. I read through this and foundit helpful.

  2. Thank you for this entry, it is incredibly useful to me! Way better written than anything else out there.

Leave a Reply

Your email address will not be published. Required fields are marked *