Results for Data Pump


1 to 60 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)

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)

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)

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 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 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

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

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

FULLDescription FULL=YES A value of FULL=YES indicates that all data and metadata from the source (either a

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

JOB_NAMEDefault: system-generated name of the form SYS___NN Purpose The job name is used to identify the import job in subsequent actions, such as when the ATTACH parameter is used to attach to a job, or to identify the job via the DBA_DATAPUMP_JOBS or USER_DATAPUMP_JOBS views. Syntax and Description JOB_NAME=jobname_string The jobname_string specifies a name of up to 30 bytes for this import job. The bytes

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

KEEP_MASTERa Data Pump job that completes successfully. The master table is automatically retained for jobs

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

PARFILErequire the use of quotation marks. See Also: \"Use of Quotation Marks On the Data Pump Command Line

Database Utilities, 11g Release 2 (11.2)

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. The mapping may not be 100 percent complete, because there are certain

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

SQLFILEperform a Data Pump Import to a SQL file using Oracle Automatic Storage Management (Oracle ASM), the

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

KILL_JOBPurpose Detaches all currently attached client sessions and then terminates the current job. It exits Import and returns to the terminal prompt. Syntax and Description KILL_JOB A job that is terminated using KILL_JOB cannot be restarted. All attached clients, including the one issuing the KILL_JOB command, receive a warning that the job is being terminated by the current user and are then detached.

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

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

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

ENCRYPTION_MODEonly in the Enterprise Edition of Oracle Database 11 g. Data Pump encryption features require that

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

FLASHBACK_TIMEparameter in a parameter file. See \"Use of Quotation Marks On the Data Pump Command Line\". Restrictions … , and this SCN is used to enable the Flashback utility. The export operation is performed with data … , Flashback Drop, or Flashback Data Archive. Example You can specify the time in any format that the

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

FULLDescription FULL=[YES | NO] FULL=YES indicates that all data and metadata are to be exported. Filtering … . Restrictions A full export does not export system schemas that contain Oracle-managed data and metadata … owned by the SYS schema are never exported. If you are exporting data that is protected by a realm

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

PARFILErequire the use of quotation marks. See Also: \"Use of Quotation Marks On the Data Pump Command Line

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

SOURCE_EDITION= edition_name is specified, then the objects from that edition are exported. Data Pump selects all

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

TRANSPORTABLEcopy the actual data files to the target database. See \"Using Data File Copying to Move Data … \". NEVER - Instructs the export job to use either the direct path or external table method to unload data … on the target system as it did on the source. But only the data that was exported for the specified

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

CONTINUE_CLIENTPurpose Changes the Export mode from interactive-command mode to logging mode. Syntax and Description CONTINUE_CLIENT In logging mode, status is continually output to the terminal. If the job is currently stopped, then CONTINUE_CLIENT will also cause the client to attempt to start the job. Example Export> CONTINUE_CLIENT

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

HELPPurpose Provides information about Data Pump Export commands available in interactive-command mode

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

Performing a Schema-Mode ExportExample 2-4 shows a schema-mode export of the hr schema. In a schema-mode export, only objects belonging to the corresponding schemas are unloaded. Because schema mode is the default mode, it is not necessary to specify the SCHEMAS parameter on the command line, unless you are specifying more than one schema or a schema other than your own. Example 2-4 Performing a Schema Mode Export > expdp hr DUMPFILE=dpump_dir1:expschema.dmp

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

Performing a Parallel Full Database Exportis a full database export, all data and metadata in the database will be exported. Dump files

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

Syntax Diagrams for Data Pump ExportThis section provides syntax diagrams for Data Pump Export. These diagrams use standard SQL syntax

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

MASTER_ONLYDefault: NO Purpose Indicates whether to import just the master table and then stop the job so that the contents of the master table can be examined. Syntax and Description MASTER_ONLY=[YES | NO] Restrictions If the NETWORK_LINK parameter is also specified, then MASTER_ONLY=YES is not supported. Example > impdp hr SCHEMAS=hr DIRECTORY=dpump_dir1 LOGFILE=schemas.log DUMPFILE=expdat.dmp MASTER_ONLY=YES


Was this page helpful?