Results for Data Pump


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


Streams Concepts and Administration, 11g Release 2 (11.2)

Information Provisioning Concepts

Data Pump Export/ImportData Pump export/import can move or copy data efficiently between databases. Data Pump can export … for a particular requirement. Data Pump exports and imports can be performed using command line … Also: Oracle Database Utilities for more information about Data

Data Mining Administrator's Guide, 11g Release 2 (11.2)

Working With Mining Model Schema Objects

Using Oracle Data PumpOracle Data Pump consists of two command-line clients and two PL/SQL APIs. The command-line clients … , EXPDP and IMPDP, provide an easy-to-use interface to the Data Pump export and import utilities … . EXPDP and IMPDP can be used to export/import entire schemas or databases. The Data Pump

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Managing Oracle Streams Advanced Queuing

Data Pump Export and ImportThe Data Pump replace and skip modes are supported for queue tables. In the replace mode an … Database Utilities for more information on Data Pump Export and Data Pump Import

XML DB Developer's Guide, 11g Release 2 (11.2)

Exporting and Importing XMLType Tables

Overview of Oracle Data PumpOracle Data Pump technology enables high-speed movement of data and metadata from one database to … another. Oracle Data Pump has two command-line clients, expdp and impdp, that invoke Data Pump Export … utility and Data Pump Import

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Instantiation and Oracle Streams Replication

Instantiating Objects Using Data Pump Export/ImportStreams environment using Oracle Data Pump export/import. This example makes the following assumptions … example in this section uses the command line Data Pump utility. You can also use the DBMS_DATAPUMP … All Databases\" Oracle Database Utilities for more information about Data Pump

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

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Instantiation and Oracle Streams Replication

Oracle Data Pump and Oracle Streams InstantiationOracle Data Pump: Data Pump Export and Object Consistency Oracle Data Pump Import and Oracle Streams … Instantiation Instantiating Objects Using Data Pump Export/Import See Also: Oracle Streams Concepts … Oracle Streams Oracle Database Utilities for

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Instantiation and Oracle Streams Replication

Data Pump Export and Object ConsistencyDuring export, Oracle Data Pump automatically uses Oracle Flashback to ensure that the exported … is required. Using the Data Pump Export utility is sufficient to ensure this consistency for Oracle … than those provided by Data Pump's default export, then you can use the Data Pump

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Instantiation and Oracle Streams Replication

Oracle Data Pump Import and Oracle Streams InstantiationThe following sections provide information about Oracle Data Pump import and Oracle Streams … instantiation: Instantiation SCNs and Data Pump Imports Instantiation SCNs and Oracle Streams Tags … Resulting from Data Pump Imports The STREAMS_CONFIGURATION Data Pump

Data Mining Administrator's Guide, 11g Release 2 (11.2)

Data Mining Administrator's Guide - Contents

ContentsViewing the Audit Trail Exporting and Importing Mining Models Using Oracle Data Pump Using EXPORT_MODEL … Conventions What's New in Oracle Data Mining Administration? Oracle Database 11 g Release 2 (11.2.0.3 … ) Oracle Data Mining Oracle Database 11 g Release 2 (11.2.0.2) New Features in Oracle Data

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

Multimedia DICOM Developer's Guide, 11g Release 2 (11.2)

Overview of DICOM Administration

9.9 Oracle Data Pump Utilities Support for the Data Model RepositoryExport and import using Oracle Data Pump is described in Oracle Database Utilities. This section … provides guidelines and examples for using the Oracle Data Pump commands expdp and impdp to perform … the ORDDATA schema can change with each database release, Oracle Data Pump Export and

Multimedia DICOM Developer's Guide, 11g Release 2 (11.2)

What's New in Oracle Multimedia DICOM?

Oracle Data Pump Utilities Support for the DICOM Data Model RepositoryOracle Data Pump Utilities support is now available for the DICOM data model repository. See … Section 9.9 for guidelines and examples that use the Oracle Data Pump commands expdp and impdp to perform … for more information about the Oracle Data Pump Export and Import

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

When to Use the Original EXP and IMP Utilities), then you must use the original Export/Import utilities to move the data. Likewise, if you are

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

Export and Import Requirements for Oracle Database UpgradesDump files generated by the Data Pump Export utility are not compatible with dump files generated … cannot be imported with the Data Pump Import (impdp) utility, and vice versa.

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

About Export Dump Files and Upgradingreleases to use when exporting data from releases earlier than Oracle Database 11 g Release 2 (11.2 … ) and then importing that data into Oracle Database 11 g Release 2 (11.2).

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

Export and Import Requirements for Downgradesfile: With Data Pump Export, use the current version's Data Pump Export utility, but set the VERSION … parameter to the target older version. Data Pump Import cannot read dump file sets created by a … perform a downgrade is to use Data Pump Export with

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

Table 7-2 Exporting Data From Release 11.1 and Importing Into Earlier ReleasesPump Export Release 11.2 with VERSION =11.1 Data Pump Import Release 11.1 Release 11.1 Release 10.2 … Data Pump Export Release 11.1 with VERSION =10.2 Data Pump Import Release 10.2 Release 10.2 Release … 10.1 Data Pump Export Release

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

Upgrading the Database Using Data Pump Export/ImportTo upgrade a database using the Data Pump Export/Import utilities, complete the following steps … : TABLE_EXISTS_ACTION=APPEND for Data Pump Import IGNORE=Y for original Import Note: If the new database is … you import: REUSE_DATAFILES=N for Data Pump Import Optionally, consider using

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

Table 7-1 Exporting Data From Releases Earlier Than 11.2 and Importing Into Release 11.2Pump Export Release 11.1 Data Pump Import Release 11.2 Release 10.2 Release 11.2 Data Pump Export … Release 10.2 Data Pump Import Release 11.2 Release 10.1 Release 11.2 Data Pump Export Release 10.1 Data … Export From

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

Export/Import Usage on Data Incompatible with a Previous ReleaseWhen you export data to a previous release, data that is incompatible with the previous release … export data to a previous release, then first remove as many incompatibilities with the previous release as possible before you export the data.

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

About Data Pump Export and Import for Upgrading Oracle DatabaseThe Data Pump Export (expdp) and Import (impdp) utilities have a similar look and feel to the … original Export (EXP) and Import (IMP) utilities, but they are completely separate. The Data Pump Export … use the Data Pump Export and Import utilities because these utilities provide greatly

Database Upgrade Guide, 11g Release 2 (11.2)

Moving Data Using Oracle Data Pump

Importing a Full Database Using a Network LinkAs an alternative to the procedure in \"Upgrading the Database Using Data Pump Export/Import\", you … can use the Data Pump Import utility with a database link to perform a full database import from a

Database New Features Guide, 11g Release 2 (11.2)

Oracle Database 11g Release 2 (11.2.0.3) New Features

2.1.17 Oracle Warehouse Builder External Table Data Pump SupportORACLE_DATAPUMP access driver. This enables OWB to use external tables to unload data to Data Pump export files … and load from Data Pump export files through external tables in extract, transform, and load (ETL … ) mappings. Use of Data Pump export files for moving

Database Data Warehousing Guide, 11g Release 2 (11.2)

Database Data Warehousing Guide - Contents

ContentsData Capture Objects Using Oracle Data Pump Restrictions on Using Oracle Data Pump with Change Data … Capture Examples of Oracle Data Pump Export and Import Commands Publisher Considerations for … Conventions What's New in Oracle Database? Oracle Database

Database Data Warehousing Guide, 11g Release 2 (11.2)

Change Data Capture

Exporting and Importing Change Data Capture Objects Using Oracle Data PumpCASCADE statement. Exporting and Importing Change Data Capture Objects Using Oracle Data Pump Oracle … Data Pump is the supported export and import utility for Change Data Capture. The following … Data Pump with Change Data Capture:

Database Data Warehousing Guide, 11g Release 2 (11.2)

Change Data Capture

Table 17-12 Methods to Drop Objects After a Data Pump Import OperationRestrictions on Using Oracle Data Pump with Change Data Capture Change Data Capture change sources … , change sets, change tables, and subscriptions are exported and imported by the Oracle Data Pump … configuration; set the Oracle Data Pump import parameter

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 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 Vault Administrator's Guide, 11g Release 2 (11.2)

What's New in Oracle Database Vault?

Oracle Data Pump SupportOracle Data Pump users now can export and import data in an Oracle Database Vault environment. See … \"Using Oracle Data Pump in an Oracle Database Vault Environment\" for more information.

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 Installation Guide for HP-UX, 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 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 Oracle Solaris, 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 and Administration Guide for Fujitsu BS2000/OSD, 11g Release 2 (11.2)

Release Notes

1.4.11 Oracle Data Pump Import and Oracle Data Pump ExportThis section provides information about Oracle Data Pump Import and Oracle Data Pump Export: Avoid … ASCII/EBCDIC conversions by the operating system, FTP, or PERCON. Oracle Data Pump Import and Oracle … Data Pump Export utilities perform their own conversions;

Database Installation Guide for IBM AIX on POWER Systems (64-Bit), 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 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 Error Messages, 11g Release 2 (11.2)

ORA-24280 to ORA-28674

ORA-26736: Data Pump errorversion. Action: Retry the operation after adding all the data files and Data Pump dump file(s) to the specified version. ORA-26736: Data Pump error

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 Backup and Recovery User's Guide, 11g Release 2 (11.2)

Glossary

exportusing Data Pump Export. You can then use Data Pump Import to import the data into a database. See Also: logical backup … The extraction of logical data (that is, not physical files) from a database into a binary file

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

Glossary

logical backupthe Oracle Data Pump Export utility. You can restore objects from logical backups using the Data Pump Import utility.

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


Was this page helpful?