What are the key features of Oracle Data Pump?

What are the key features of Oracle Data Pump?

As a result, Data Pump-based export and import clients (expdp and impdp) support all the features of the original export and import clients (exp and imp), as well as many new features, such as dump file encryption and compression, checkpoint restart, job size estimation, very flexible, fine-grained object selection.

What is data Pump in Oracle Database?

Oracle Data Pump technology enables very high-speed movement of data and metadata from one database to another. Oracle Data Pump is available only on Oracle Database 10g release 1 (10.1) and later.

Is Oracle Data Pump platform independent?

Data Pump is platform independent – it can migrate Oracle Databases running on any platform. Data Pump is faster to migrate database than using RMAN.

What is data Pump in Oracle 12c?

You can use Data Pump to transport an entire database from one instance to another. This capability includes new Oracle 12c pluggable databases as well as older nonpluggable databases. You can use this to move a database to a new server environment or to upgrade to a higher database version.

How does Datapump work?

With the data pump you can move data and metadata from one database to another. Oracle Data Pump can be used in 2 different ways: – A command-line function: impdp and expdp. Therefore, files generated by the original Export (exp) utility cannot be imported with the Data Pump Import (impdp) utility.

What is difference between EXP IMP and data Pump in Oracle?

Exports (exp/imp) represent database metadata information as DDLs in the dump file, but in datapump, it represents in XML document format. Datapump has parallel execution but in exp/imp single stream execution. Datapump does not support sequential media like tapes, but traditional export supports.

How do data pumps work?

What is data Pump export in Oracle?

Data Pump Export (hereinafter referred to as Export for ease of reading) is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be imported only by the Data Pump Import utility.

What can data pump be used for in a database?

Data Pump allows for the selective copying of a schema or a set of tables from one database to another. It also allows for the selective copying of rows with the query option. Data Pump exports can be used to backup schema definitions so that empty schemas can be recreated in test/development environments.

When is a PGA created in an Oracle Server?

A PGA is a nonshared memory region that contains data and control information exclusively for use by an Oracle process. The PGA is created by Oracle Database when an Oracle process is started. One PGA exists for each server process and background process.

Which is the client process in data pump?

The client process is the process which is started over the client terminal that initiates a Data Pump export or import job. This is the process which calls up the Data Pump API. This could be running from anywhere, either a terminal prompt, OEM or from some API as well. Once the job is kicked in, the client process itself is not needed.

What are the memory structures associated with Oracle?

The basic memory structures associated with Oracle Database include: The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes.