Results for Data Pump


1 to 40 of 32169 results. Prev  Next
Results per page:   20  | 40 | 60


Database Backup and Recovery User's Guide

Creating Transportable Tablespace Sets

27.5.2 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

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

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

Data Pump Import

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

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

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

Data Pump Import

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

Data Pump Export

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

Overview of Oracle Data Pump

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

Overview of Oracle Data Pump

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

Database Utilities

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

Data Pump Export

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

Overview of Oracle Data Pump

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

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

Database Security Guide

Configuring Audit Policies

Auditing Oracle Data Pump Eventsdbms_data_mining.rename_model('dmuser1.nb_model1', 'nb_model'); END; Auditing Oracle Data Pump Events You can use the CREATE … AUDIT POLICY statement to audit Oracle Data Pump. About Auditing Oracle Data Pump Events The CREATE … AUDIT POLICY statement COMPONENT clause must be set to

Database Utilities

Overview of Oracle Data Pump

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: Data Pump does not support … any CDB-wide operations. Data

Database Utilities

The Data Pump API

6 The Data Pump APIGo to main content 14/40 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 Interface

Database Utilities

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

Oracle Data Pump

Part I Oracle Data PumpThe following topics are discussed: Overview of Oracle Data Pump Oracle Data Pump technology, which … enables very high-speed movement of data and metadata from one database to another. Data Pump … Export The Oracle Data Pump Export

Database Utilities

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

Overview of Oracle Data Pump

How Does Data Pump Move Data?For information about the methods Data Pump uses to move data in and out of databases, and when … Network Link Import to Move Data Note: Data Pump does not load tables with disabled unique indexes. To … each of the methods is used, see the following topics: Using Data

Database Utilities

Overview of Oracle Data Pump

How Does Data Pump Handle Timestamp Data?Note: The information in this section applies only to Oracle Data Pump running on Oracle Database … import jobs that involve the timestamp data types TIMESTAMP WITH TIMEZONE and TIMESTAMP WITH LOCAL TIMEZONE.

Database Upgrade Guide

Migrating Data Using Oracle Data Pump

7 Migrating Data Using Oracle Data PumpUse the Export and Import utilities in Oracle Data Pump to migrate data from one database to … another. Oracle Data Pump provides high performance Export ( expdp ) and Import ( impdp ) utilities. These … information about Data Pump and the Export and Import utilities

Database Utilities

Data Pump Export

Data FiltersData specific filtering is implemented through the QUERY and SAMPLE parameters, which specify … restrictions on the table rows that are to be exported. Data filtering can also occur indirectly because … of metadata filtering, which can include or exclude table objects along with any associated row data … . Each data

Database Utilities

Data Pump Export

CONTENTDefault: ALL Purpose Enables you to filter what Export unloads: data only, metadata only, or both … . Syntax and Description CONTENT=[ALL | DATA_ONLY | METADATA_ONLY] ALL unloads both data and metadata … . This is the default. DATA_ONLY unloads only table row data; no database object definitions are … unloaded. METADATA_ONLY unloads

Database Utilities

Data Pump Export

METRICSthe Data Pump log file. Syntax and Description METRICS=[YES | NO] When METRICS=YES is used, the number … of objects and the elapsed time are recorded in the Data Pump log file. Restrictions None Example

Database Utilities

Data Pump Export

STATUSDefault: 0 Purpose Specifies the frequency at which the job status display is updated. Syntax and Description STATUS=[integer] If you supply a value for integer, it specifies how frequently, in seconds, job status should be displayed in logging mode. If no value is entered or if the default value of 0 is used, then no additional information is displayed beyond information about the completion of each

Database Utilities

Data Pump Export

VERSIONthat this does not mean that Data Pump Export can be used with releases of Oracle Database prior to … Oracle Database 10 g release 1 (10.1). Data Pump Export only works with Oracle Database 10 g release … earlier than 11.2 is not allowed. If the Data Pump Export VERSION parameter is

Database Utilities

Data Pump Export

VIEWS_AS_TABLESDescription VIEWS_AS_TABLES=[schema_name.]view_name[:table_name],... Data Pump exports a table with … the same columns as the view and with row data fetched from the view. Data Pump also exports objects … can be used by itself or along with the TABLES parameter. If either is used, Data

Database Utilities

Data Pump Export

Commands Available in Export's Interactive-Command Modejob from the Data Pump Export prompt in interactive-command mode. Table 2-1 Supported Activities in … Data Pump Export's Interactive-Command Mode Activity Command Used Add additional dump files. ADD_FILE

Database Utilities

Data Pump Performance

Tuning PerformanceData Pump is designed to fully use all available resources to maximize throughput and minimize

Database Utilities

Data Pump Legacy Mode

Log FilesData Pump Export and Import do not generate log files in the same format as those created by … be updated to handle the log file format used by Data Pump Export and Import. For example, the … message Successfully Terminated does not appear in Data Pump log files.

Database Utilities

Data Pump Legacy Mode

Exit StatusData Pump Export and Import have enhanced exit status values to allow scripts to better determine

Database Utilities

Data Pump Import

Metadata FiltersData Pump Import provides much greater metadata filtering capability than was provided by the … to be included or excluded from a Data Pump operation. For example, you could request a full import

Database Utilities

Data Pump Import

ACCESS_METHOD… The available options are: AUTOMATIC — This is the default. Data Pump determines the best way to … Data Pump to automatically select the most efficient method. DIRECT_PATH — Data Pump uses direct … path load for every table. EXTERNAL_TABLE — Data Pump

Database Utilities

Data Pump Import

ENCRYPTION_PWD_PROMPTDefault: NO Purpose Specifies whether Data Pump should prompt you for the encryption password … line to instruct Data Pump to prompt you for the encryption password, rather than you entering it … and ENCRYPTION_PASSWORD parameters is prohibited. Example The following example shows Data Pump

Database Utilities

Data Pump Import

HELPDefault: NO Purpose Displays online help for the Import utility. Syntax and Description HELP=YES If HELP = YES is specified, then Import displays a summary of all Import command-line parameters and interactive commands. Example > impdp HELP = YES This example will display a brief description of all Import parameters and commands.

Database Utilities

Data Pump Import

LOGTIMEphases of a Data Pump operation. Such information can be helpful in diagnosing performance problems and

Database Utilities

Data Pump Import

METRICSthe Data Pump log file. Syntax and Description METRICS=[YES | NO] When METRICS=YES is used, the number … of objects and the elapsed time are recorded in the Data Pump log file. Restrictions None Example

Database Utilities

Data Pump Import

REMAP_SCHEMADefault: There is no default Purpose Loads all objects from the source schema into a target schema. Syntax and Description REMAP_SCHEMA=source_schema:target_schema Multiple REMAP_SCHEMA lines can be specified, but the source schema must be different for each one. However, different source schemas can map to the same target schema. Note that the mapping may not be 100 percent complete; see the Restrictions





Was this page helpful?

Integrated Cloud Applications & Platform Services