You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for Data Pump


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


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

LOGFILEis relative to the server and not the client. Note: Data Pump Import writes the log file using the … file than they are when displayed on the client output screen. Restrictions To perform a Data Pump

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_DATADefault: There is no default Purpose The REMAP_DATA parameter allows you to remap data as it is … whose data is to be remapped. The maximum number of columns that can be remapped for a single table … specified regn as part of the REMPA_DATA specification. Remapping LOB column data of a remote table

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

REMAP_DATAFILEspecify this parameter. See Also: \"Use of Quotation Marks On the Data Pump Command Line\" Example … Default: There is no default Purpose Changes the name of the source data file to the target data … file name in all SQL statements where the source data file is referenced: CREATE TABLESPACE, CREATE

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

SCHEMASDefault: There is no default Purpose Specifies that a schema-mode import is to be performed. Syntax and Description SCHEMAS=schema_name [,...] If you have the DATAPUMP_IMP_FULL_DATABASE role, then you can use this parameter to perform a schema-mode import by specifying a list of schemas to import. First, the user definitions are imported (if they do not already exist), including system and role grants,

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

PARALLELPurpose Enables you to increase or decrease the number of active worker processes and/or PQ slaves for the current job. Syntax and Description PARALLEL=integer PARALLEL is available as both a command-line parameter and an interactive-mode parameter. You set it to the desired number of parallel processes. An increase takes effect immediately if there are enough resources and if there is enough work

Database Utilities, 11g Release 2 (11.2)

Data Pump Import

START_JOBcannot be currently executing). The job is restarted with no data loss or corruption after an unexpected

Database Utilities, 11g Release 2 (11.2)

Data Pump Legacy Mode

Parameter MappingsThis section describes how original Export and Import parameters map to the Data Pump Export and … Import parameters that supply similar functionality. See Also: Chapter 2, \"Data Pump Export\" Chapter … 3, \"Data Pump Import\" Chapter 21, \"Original Export\" Chapter 22, \"Original Import\"

Database Utilities, 11g Release 2 (11.2)

Data Pump Legacy Mode

Using Original Export Parameters with Data PumpData Pump Export accepts original Export parameters when they map to a corresponding Data Pump … parameter. Table 4-1 describes how Data Pump Export interprets original Export parameters. Parameters … that have the same name and functionality in both original Export and Data

Database Utilities, 11g Release 2 (11.2)

Data Pump Legacy Mode

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

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

Metadata FiltersMetadata filtering is implemented through the EXCLUDE and INCLUDE parameters. The EXCLUDE and INCLUDE parameters are mutually exclusive. Metadata filters identify a set of objects to be included or excluded from an Export or Import operation. For example, you could request a full export, but without Package Specifications or Package Bodies. To use filters correctly and to get the results you expect,

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

DATA_OPTIONSstored only as CLOBs, then it is not necessary to specify the XML_CLOBS option because Data Pump … object-relational (schema-based), binary, or CLOB formats, then Data Pump exports them in compressed … Default: There is no default. If this parameter is not used, then the special data handling options

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

JOB_NAMEDefault: system-generated name of the form SYS_EXPORT__NN Purpose Used to identify the export job in subsequent actions, such as when the ATTACH parameter is used to attach to a job, or to identify the job using 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 export job. The bytes must

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

LOGFILE… Restrictions To perform a Data Pump Export using Oracle Automatic Storage Management (Oracle ASM), you … use the default: > expdp hr DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp LOGFILE=hr_export.log Note: Data Pump

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

START_JOBexecuting). The job is restarted with no data loss or corruption after an unexpected failure or after you

Database Utilities, 11g Release 2 (11.2)

Data Pump Export

Estimating Disk Space Needed in a Table-Mode Exportcommand to use the BLOCKS method to estimate the number of bytes required to export the data in the … printed in the log file and displayed on the client's standard output device. The estimate is for table row data only; it does not include metadata.