Results for Data Pump


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


Database Installation Guide for Linux, 11g Release 2 (11.2)

What's New in Oracle Database 11g Release 2 (11.2)

Oracle Data Pump Export and Oracle Data Pump ImportData Pump provides a legacy mode in which you can use original export and import parameters when … performing Oracle Data Pump export and import operations. See Also: Oracle Database Utilities for more information about Data Pump Legacy Mode

Database Installation Guide for Microsoft Windows, 11g Release 2 (11.2)

Installation Guide

Data Pump Export and Data Pump ImportData Pump provides a legacy mode in which you can use original Export and Import parameters when … performing Data Pump Export and Import operations. See Also: Oracle Database Utilities for more information about Data Pump legacy mode

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Oracle Data Pump

Oracle Data PumpPart I Oracle Data Pump This part contains the following chapters: Chapter 1, \"Overview of Oracle … Data Pump\" This chapter provides an overview of Oracle Data Pump technology, which enables very … high-speed movement of data and metadata from one database to another.

Database Utilities, 11g Release 2 (11.2)

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, invoke the Data

Database Utilities, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Data Pump Export

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

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

Data Pump Export Modesexported include SYS, ORDSYS, and MDSYS. See Also: \"Examples of Using Data Pump Export\" Full Export … schemas; they contain Oracle-managed data and metadata. Examples of system schemas that are not … the TABLES parameter, then only object metadata is unloaded. To move the actual data, you copy the … data

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

3 Data Pump ImportThis chapter describes the Oracle Data Pump Import utility (impdp). The following topics are … discussed: What Is Data Pump Import? Invoking Data Pump Import Filtering During Import Operations … Examples of Using Data Pump Import Syntax Diagrams for

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

Invoking Data Pump ImportThe Data Pump Import utility is invoked 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, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Data Pump Export

2 Data Pump ExportThis chapter describes the Oracle Data Pump Export utility (expdp). The following topics are … discussed: What Is Data Pump Export? Invoking Data Pump Export Filtering During Export Operations … Examples of Using Data Pump Export Syntax Diagrams for

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

Data Pump Import Modes\" \"Using Data File Copying to Move Data\" Tablespace Mode A tablespace-mode import is specified using the … (specified with the NETWORK_LINK parameter). There are no dump files involved. The actual data files

Database Utilities, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Data Pump Performance

5 Data Pump PerformanceThe Data Pump utilities are designed especially for very large databases. If your site has very … Data Pump Export and Import Tuning Performance Initialization Parameters That Affect Data Pump … Performance Performance of metadata extraction and database object creation in Data

Database Utilities, 11g Release 2 (11.2)

The Data Pump API

6 The Data Pump APIGo to main content 14/36 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. This chapter … provides details about

Database Utilities, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Data Pump Legacy Mode

4 Data Pump Legacy Modefor many years. To ease the transition to the newer Data Pump Export and Import utilities, Data Pump … provides a legacy mode which allows you to continue to use your existing scripts with Data Pump. Data … present, either on the command line or in a script. As Data

Database Utilities, 11g Release 2 (11.2)

Overview of Oracle Data Pump

How Does Data Pump Move Data?For information about how Data Pump moves data in and out of databases, see the following sections … Data Using Conventional Path to Move Data Using Network Link Import to Move Data Note: Data Pump does … : Using Data File Copying to

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

7 Moving Data Using Oracle Data PumpWhen upgrading Oracle Database, you can use the Export and Import utilities in Oracle Data Pump to … move data from one database to another. This chapter contains the following topics: About Data Pump … Upgrades Upgrading the Database Using Data Pump Export/Import See

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

EXCLUDEMarks On the Data Pump Command Line\" If the object_type you specify is CONSTRAINT, GRANT, or USER

Database Utilities, 11g Release 2 (11.2)

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

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

Activity Command Usedjob for later restart. STOP_JOB The following are descriptions of the commands available in the interactive-command mode of Data Pump Export.

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

ADD_FILEPurpose Adds additional files or substitution variables to the export dump file set. Syntax and Description ADD_FILE=[directory_object:]file_name [,...] Each file name can have a different directory object. If no directory object is specified, then the default is assumed. The file_name must not contain any directory path information. However, it can include a substitution variable, %U, which indicates

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

Using Interactive Mode to Stop and Reattach to a Jobrunning, press Ctrl+C. This will start the interactive-command interface of Data Pump Export. In the

Database Utilities, 11g Release 2 (11.2)

Data Pump Performance

Tuning PerformanceData Pump technology fully uses all available resources to maximize throughput and minimize elapsed

Database Utilities, 11g Release 2 (11.2)

Data Pump Performance

Initialization Parameters That Affect Data Pump PerformanceThe settings for certain initialization parameters can affect the performance of Data Pump Export

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

CLUSTERDefault: Y ES Purpose Determines whether Data Pump can use Oracle Real Application Clusters (Oracle … | NO] To force Data Pump Import to use only the instance where the job is started and to replicate … parameter are those involving large amounts of data. See Also: \"SERVICE_NAME\" \"Oracle RAC

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

ENCRYPTION_PASSWORDparameter is valid only in the Enterprise Edition of Oracle Database 11 g. Data Pump encryption features … accessing encrypted column data in the dump file set. This prevents unauthorized access to an encrypted dump

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

FLASHBACK_SCNoperation is performed with data that is consistent up to the specified scn_number. Note: If you are on a … logical standby. See Oracle Data Guard Concepts and Administration for information about logical standby … Oracle Database. It is not applicable to Flashback Database, Flashback Drop, or Flashback Data Archive … =source_database_link

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

SERVICE_NAME: If you start a Data Pump job on instance A and specify CLUSTER=YES (or accept the default, which is … YES ) and you do not specify the SERVICE_NAME parameter, then Data Pump creates workers on all … instances: A, B, C, and D, depending on the degree of parallelism specified. If you start a Data Pump

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

SKIP_UNUSABLE_INDEXESindexes. If indexes used to enforce constraints are marked unusable, then the data is not imported into … that table. Note: This parameter is useful only when importing data into an existing table. It has no

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

SOURCE_EDITIONfrom that edition are imported. Data Pump selects all inherited objects that have not changed and … with the name of the source database from which you were importing data. The EXCLUDE=USER parameter

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

TABLE_EXISTS_ACTIONwhether the target table already exists or not. Note: When Data Pump detects that the source table and … , then the load fails and no data is loaded. You can override this behavior by specifying DATA_OPTIONS … =SKIP_CONSTRAINT_ERRORS on the Import command line. If you have data that must be loaded, but may … cause

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

TRANSPORT_TABLESPACESof Quotation Marks On the Data Pump Command Line\" Restrictions You cannot export transportable … ACCESS_METHOD parameter for Data Pump Import. Example In the following example, the source_database_link … the data is imported are automatically created by Data Pump.You do not need to

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

VERSION). Note that this does not mean that Data Pump Import can be used with releases of Oracle Database … earlier than 10.1. Data Pump Import only works with Oracle Database 10 g release 1 (10.1) or later. The … example, 11.2.0). In Oracle Database 11 g, this value must be 9.2.0 or higher. See Also: \"Moving Data

Database Utilities, 11g Release 2 (11.2)

Data Pump Legacy Mode

Management of File Locations in Data Pump Legacy ModeOriginal Export and Import and Data Pump Export and Import differ on where dump files and log files … can be written to and read from because the original version is client-based and Data Pump is … may also contain a path specification. Data Pump Export and Import use the DUMPFILE and

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

Parameters Available in Import's Command-Line ModeThis section describes the parameters available in the command-line mode of Data Pump Import. Be … Use of Quotation Marks On the Data Pump Command Line Many of the descriptions include an example of … , you must enter an equal sign (=) and a value. Data Pump has no other way of knowing

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

DATA_OPTIONSDefault: There is no default. If this parameter is not used, then the special data handling options … types of data should be handled during import operations. Syntax and Description DATA_OPTIONS … import operation to use the APPEND hint while loading the data object. Disabling the APPEND hint can … be useful if there is a small





Was this page helpful?

Integrated Cloud Applications & Platform Services