What are the Data Pump Export Examples?

Things released by Data Pump Export Application can be brought in into a data source using Details Push Transfer Application. The following explains how to use Details Pump Export Application to import objects

Importing Complete Dispose of File

If you want to Transfer all the objects in a dump data file you can kind the following control.

$impdp hr/hr DUMPFILE=dpump_dir1:expfull.dmp FULL=y


This example imports everything from the expfull.dmp dump data file. In this example, a DIRECTORY parameter is not offered. Therefore, a directory item must be offered on both the DUMPFILE parameter and the LOGFILE parameter

Importing Things of One Schema to another Schema

The following example plenty all platforms owned by hr schema to scott schema

$ impdp SYSTEM/password DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp


If SCOTT consideration are available in the data source then hr objects will be packed into scott schema. If scott consideration does not are available, then Transfer Application can provide the SCOTT consideration with an useless security password because, the dump data file was released by the customer SYSTEM and brought in by the customer SYSTEM who has DBA rights.

Loading Things of one Tablespace to another Tablespace.

You can use remap_tablespace choice to import objects of one tablespace to another tablespace by providing the command

$ impdp SYSTEM/password DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp


The above example plenty platforms, saved in customers tablespace, in the revenue tablespace.

Generating SQL File containing DDL instructions using Details Push Import

You can produce SQL data file which contains all the DDL instructions which Transfer would have implemented if you actually run Transfer utility

The following is an example of using the SQLFILE parameter.

$ impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp


A SQL data file known as expfull.sql is published to dpump_dir2.

Importing objects of only a Particular Schema

If you have the IMP_FULL_DATABASE part, you can use this parameter to carry out a schema-mode import by specifying only one schema other than your own or a record of schemas to import. First, the schemas themselves are manufactured (if they do not already exist), such as system and part allows, security password record, and so on. Then all objects included within the schemas are brought in. Nonprivileged customers can specify only their own schemas. In that situation, no details about the schema meaning is brought in, only the objects included within it.


The following is an example of using the SCHEMAS parameter. You can make the expdat.dmp data file used in this example by operating the example offered for the Trade SCHEMAS parameter.

$ impdp hr/hr SCHEMAS=hr,oe DIRECTORY=dpump_dir1

LOGFILE=schemas.log DUMPFILE=expdat.dmp

The hr and oe schemas are brought in from the expdat.dmp data file. The log data file, schemas.log, is published to dpump_dir1

Importing Only Particular Tables

The following example reveals a easy use of the TABLES parameter to import only the workers and tasks platforms from the expfull.dmp data file. You can make the expfull.dmp dump data file used in this example by operating the example offered for the Complete Database Trade in Past Subject.

$impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp TABLES=employees,jobs

This will import only workers and tasks platforms from the DUMPFILE.

Running Details Push Transfer Application in Entertaining Mode

Similar to the DATA PUMP EXPORT utility the Details Push Transfer Jobs can also be revoked, began again or murdered. And, you can affix to an already current import job from any customer device.

For Example, assume a DBA begins a publishing by writing the following control at one customer device CLNT1 by writing the following command

$impdp scott/tiger@mydb FULL=y DIRECTORY=data_pump_dir

DUMPFILE=full.dmp LOGFILE=myfullexp.log JOB_NAME=myfullJob

After a while, the DBA wants to quit this job momentarily. Then he clicks CTRL+C to initiate interactive method. He will get the Import> immediate where he can kind interactive commands

Now he wants to quit this export job so he will kind the following command


Are you sure you wish to quit this job ([y]/n): y

The job is placed in a ceased condition and leaves the customer.

After completing his other perform, the DBA wants to proceed the export job and the customer device from where he actually began the job is closed because, the customer has closed his/her cottage. So now the DBA will go to another customer device and he reattach to the job by writing the following command

$ impdp hr/hr@mydb ATTACH=myfulljob

After the job position is shown, he can problem the CONTINUE_CLIENT control to proceed signing method and reboot the myfulljob job.


A concept is shown that the job has been reopened, and handling position is outcome to the customer.

Note: After reattaching to the Job a DBA can also destroy the job by writing KILL_JOB, if he doesn’t want to follow the import job. Join the best oracle training to get oracle dba jobsto make your career in this field.

oracle course,dba training,oracle certificate,

Like what you read? Give athene_marry a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.