How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
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
Specifying Locations for Data Pump Files → You 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
5 Data Pump Performance → The 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
Data Pump Import Interfaces → You 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
Data Pump Exit Codes → Oracle 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
Auditing Data Pump Jobs → You 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
Data Pump Export Modes → exported 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
2 Data Pump Export → The 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
3 Data Pump Import → The 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
Invoking Data Pump Export → The 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 \"
Data Pump Components → Oracle 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
Data Pump Export Interfaces → You 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 Data … Pump Command Line \". Interactive-Command Interface: Stops logging to the terminal and displays the
Invoking Data Pump Import → The 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
Data Pump Import Modes → The 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
Using Data Pump With CDBs → not 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
Auditing Oracle Data Pump Events → You 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
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
6 The Data Pump API → Go 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
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
4 Data Pump Legacy Mode → for 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