You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for Data Pump


1 to 20 of 30693 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Administrator's Guide, 12c Release 1 (12.1)

Managing Memory

6.7.7 Data Pump and the IM Column Store=INMEMORY:y option of the impdp command. With this option, Data Pump keeps the IM column store clause for … all objects that have one. When the TRANSFORM=INMEMORY:n option is specified, Data Pump drops the IM

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Creating Transportable Tablespace Sets

Specifying Locations for Data Pump FilesYou can change the names of the Data Pump export dump file for the transportable set, the sample … import script for use at the target database, the log file generated by Data Pump Export, and the … and named as follows: The Data Pump export dump file is named dmpfile.dmp. The export

Database Utilities, 12c Release 1 (12.1)

Data Pump Performance

5 Data Pump PerformanceThe Data Pump Export and Import utilities are designed especially for very large databases. If you … database object creation in Data Pump Export and Import remains essentially equivalent to that of the … original Export and Import utilities.) Topics that will help you to understand why Data Pump

Database Utilities, 12c Release 1 (12.1)

Data Pump Import Interfaces

Data Pump Import InterfacesYou can interact with Data Pump Import by using a command line, a parameter file, or an interactive … parameters whose values require quotation marks. See \" Use of Quotation Marks On the Data Pump

Database Utilities, 12c Release 1 (12.1)

Data Pump Exit Codes

Data Pump Exit CodesOracle Data Pump provides the results of export and import operations immediately upon completion … . In addition to recording the results in a log file, Data Pump may also report the outcome in a … process exit code. This allows you to check the outcome of a Data Pump job from the command

Database Utilities, 12c Release 1 (12.1)

Auditing Data Pump Jobs

Auditing Data Pump JobsYou can perform auditing on Data Pump jobs in order to monitor and record selected user database … actions. Data Pump uses unified auditing, in which all audit records are centralized in one place. To

Database Utilities, 12c Release 1 (12.1)

Data Pump Export Modes

Data Pump Export Modesexported include SYS, ORDSYS, and MDSYS. See Also: \" Examples of Using Data Pump Export \" … user schemas; they contain Oracle-managed data and metadata. Examples of system schemas that are not

Database Utilities, 12c Release 1 (12.1)

Data Pump Export

2 Data Pump ExportThe Oracle Data Pump Export utility is used to unload data and metadata into a set of operating … system files called a dump file set. Topics: What Is Data Pump Export? Invoking Data Pump Export … in Export's Interactive-Command Mode Examples of Using Data

Database Utilities, 12c Release 1 (12.1)

Data Pump Import

3 Data Pump ImportThe Oracle Data Pump Import utility is used to load an export dump file set into a target database … database with no intervening files. Topics: What Is Data Pump Import? Invoking Data Pump Import … in Import's Interactive-Command Mode Examples of Using Data Pump

Database Utilities, 12c Release 1 (12.1)

Invoking Data Pump Export

Invoking Data Pump ExportThe Data Pump Export utility is started using the expdp command. The characteristics of the export … invoking Export: \" Data Pump Export Interfaces \" \" Data Pump Export Modes \" \" Network Considerations \"

Database Utilities, 12c Release 1 (12.1)

Data Pump Components

Data Pump ComponentsOracle Data Pump is made up of three distinct parts: The command-line clients, expdp and impdp The … DBMS_DATAPUMP PL/SQL package (also known as the Data Pump API) The DBMS_METADATA PL/SQL package … (also known as the Metadata API) The Data Pump clients, expdp and impdp, start the Data

Database Utilities, 12c Release 1 (12.1)

Data Pump Export Interfaces

Data Pump Export InterfacesYou can interact with Data Pump Export by using a command line, a parameter file, or an interactive … are using parameters whose values require quotation marks. See \" Use of Quotation Marks On the DataPump Command Line \". Interactive-Command Interface: Stops logging to the terminal and displays the

Database Utilities, 12c Release 1 (12.1)

Invoking Data Pump Import

Invoking Data Pump ImportThe Data Pump Import utility is started using the impdp command. The characteristics of the import … behavior is not the same as for general users. Note: Be aware that if you are performing a Data Pump … information about invoking Import: \" Data Pump Import Interfaces \" \" Data

Database Utilities, 12c Release 1 (12.1)

Data Pump Import Modes

Data Pump Import ModesThe import mode determines what is imported. The specified mode applies to the source of the operation, either a dump file set or another database if the NETWORK_LINK parameter is specified. When the source of the import operation is a dump file set, specifying a mode is optional. If no mode is specified, then Import attempts to load the entire dump file set in the mode in which the export operation

Database Utilities, 12c Release 1 (12.1)

Using Data Pump With CDBs

Using Data Pump With CDBsnot a CDB. You can use Data Pump to migrate all, or portions of, a database from a non-CDB into a … Data Pump with PDBs is identical to using Data Pump with a non-CDB. Note: In Oracle Database 12 c … Release 1 (12.1), Data Pump does not support any CDB-wide

Database Security Guide, 12c Release 1 (12.1)

Configuring Audit Policies

Auditing Oracle Data Pump EventsYou can use the CREATE AUDIT POLICY statement to audit Oracle Data Pump. Topics: About Auditing … Oracle Data Pump Events Oracle Data Pump Unified Audit Trail Events Configuring a Unified Audit Policy … for Oracle Data Pump Example: Auditing Oracle Data

Database Utilities, 12c Release 1 (12.1)

What Is Data Pump Import?

What Is Data Pump Import?Data Pump Import (hereinafter referred to as Import for ease of reading) is a utility for loading … a proprietary, binary format. During an import operation, the Data Pump Import utility uses these … import. Data Pump Import enables you to specify whether a job should move a subset of

Database Utilities, 12c Release 1 (12.1)

The Data Pump API

6 The Data Pump APIGo to main content 205/1019 6 The Data Pump API The Data Pump API, DBMS_DATAPUMP, provides a high … . The Data Pump Export and Data Pump Import utilities are based on the Data Pump API. Topics: How … Does the Client

Database Utilities, 12c Release 1 (12.1)

What Is Data Pump Export?

What Is Data Pump Export?Data Pump Export (hereinafter referred to as Export for ease of reading) is a utility for unloading … can be imported only by the Data Pump Import utility. The dump file set can be imported on the same … are written in a proprietary, binary format. During an import operation, the Data Pump

Database Utilities, 12c Release 1 (12.1)

Data Pump Legacy Mode

4 Data Pump Legacy Modefor many years. Data Pump provides a legacy mode which allows you to continue to use your existing … scripts with Data Pump. Data Pump enters legacy mode when it determines that a parameter unique to … original Export or Import is present, either on the command line or in a script. As