<<Back to Oracle DATAPUMP Main Page
Overview of Oracle Datapump Utility
Oracle Data Pump (expdp, impdp) introduced from oracle 10g is a replacement of conventional exp/imp utility. Oracle Data Pump is a newer, faster and more flexible alternative than the "exp" and "imp" utilities. Oracle Datapump utility is used to unload and load data with in the same or different database.What Is Data Pump Export?
Data Pump Export is a utility for unloading data and metadata into a set of operating system files called a dump file set.What Is Data Pump Import?
The dump file set(generated by Export) can be imported only by the Data Pump Import utility in same or different databaseHow to Invoke Data Pump Export?
The Data Pump Export utility is started using the expdp command.How to Invoke Data Pump Import?
The Data Pump Import utility is started using the impdp command.Modes of Data Pump Export.
Export provides different modes for unloading different portions of the database.These are
Full Mode:A full database export is specified using the FULL parameter. In a full database export, the entire database is unloaded. This mode requires that you have the DATAPUMP_EXP_FULL_DATABASE role.
Schema Mode:A schema export is specified using the SCHEMAS parameter. This is the default export mode. If you have the DATAPUMP_EXP_FULL_DATABASE role, then you can export list of schemas else you can export only your schemas
Table Mode:A table mode export is specified using the TABLES parameter.
Tablespace Mode:A tablespace export is specified using the TABLESPACES parameter. In tablespace mode, only the tables contained in a specified set of tablespaces are unloaded.
Transportable Tablespace Mode:A transportable tablespace export is specified using the TRANSPORT_TABLESPACES parameter. In transportable tablespace mode, only the metadata for the tables (and their dependent objects) within a specified set of tablespaces is exported. The tablespace data files are copied in a separate operation. Then, a transportable tablespace import is performed to import the dump file containing the metadata and to specify the data files to use.
Use of Datapump
oracle datapump utility (expdp and impdp) can be used fordatabase backup and restore
database migration
database upgrade
Comments
Post a Comment