Results for Data Pump


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


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





Was this page helpful?

Integrated Cloud Applications & Platform Services