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 direct path loads


1 to 20 of 704 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Utilities, 11g Release 2 (11.2)

SQL*Loader Control File Reference

Discontinued Direct Path LoadsIn a direct path load, the behavior of a discontinued load varies depending on the reason the load … SQL*Loader loads data already read from the data file into other tables and then commits the data. In

Database Utilities, 11g Release 2 (11.2)

SQL*Loader Concepts

Direct Path LoadsA direct path load parses the input records according to the field specifications, converts the … takes place. Direct path load is much faster than conventional path load, but entails several … restrictions. See Also: \"Direct Path Load\" Parallel Direct

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Data Conversion During Direct Path LoadsDuring a direct path load, data conversion occurs on the client side rather than on the server side

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Data Recovery During Direct Path LoadsRecovery and Direct Path Loads If redo log file archiving is enabled (you are operating in ARCHIVELOG mode … Recovery and Direct Path Loads Because SQL*Loader writes directly to the database files, all rows … SQL*Loader provides full support for data recovery when using the direct

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Preallocating Storage for Faster Loadingfaster loads into a new table, allocate the required extents when the table is created. To calculate

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Minimizing Use of the Redo Log… Disabling Archiving If archiving is disabled, then direct path loads do not generate full image redo … data. By default, a direct path load is RECOVERABLE. The following is an example of specifying the … One way to speed a direct load dramatically is to minimize use of the

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Parameters for Parallel Direct Path LoadsWhen you perform parallel direct path loads, there are options available for specifying attributes … for parallel direct path loads: For nonpartitioned tables: The specified file must be in the … concurrent direct path load session use files located

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

General Performance Improvement Hintsset Performance is optimized if all character sets are the same. For direct path loads, it is best … the same, then character set conversion buffers are not allocated. Use direct path loads. Use the … on each column that has a clause associated with it for every row loaded. Use parallel

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

12 Conventional and Direct Path LoadsOptimizing Performance of Direct Path Loads Optimizing Direct Path Loads on Multiple-CPU Systems … This chapter describes SQL*Loader's conventional and direct path load methods. The following topics … are discussed: Data Loading Methods Conventional

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Conventional Path Loaddramatically. See Also: \"Discontinued Conventional Path Loads\" … Conventional path load (the default) uses the SQL INSERT statement and a bind array buffer to load … performs a conventional path load, it competes equally with all other processes for buffer … fill them on each insert. Although appropriate during

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Direct Path Load of a Partitioned or Subpartitioned Tableindexes (which can also be partitioned). Note that a direct path load of a partitioned or … you are performing a direct path load into multiple partitions and a space error occurs, then the

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Field Defaults on the Direct PathDefault column specifications defined in the database are not available when you use direct path

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Loading into SynonymsYou can load data into a synonym for a table during a direct path load, but the synonym must point … directly to either a table or a view on a simple table. Note the following restrictions: Direct path … mode cannot be used if the view is on a table that has user-defined types or XML data. In direct

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Optimizing Direct Path Loads on Multiple-CPU SystemsIf you are performing direct path loads on a multiple-CPU system, then SQL*Loader uses … arrays are large enough to generate multiple direct path stream buffers for loads Data conversions … Interface Programmer's Guide for more information about the concepts of direct

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Concurrent Conventional Path LoadsPerformance with Concurrent Conventional Path Loads\". You can use this technique to load the same … Using multiple conventional path load sessions executing concurrently is discussed in \"Increasing

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Initiating Multiple SQL*Loader Sessionsfiles to use for the direct path load. Note: Indexes are not maintained during a parallel load. Any … Each SQL*Loader session takes a different data file as input. In all sessions executing a direct … specified in the control file with the OPTIONS clause. For example, to invoke three SQL*Loader directpath

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Setting Up for Direct Path LoadsTo prepare the database for direct path loads, you must run the setup script, catldr. sql, to … loads to. You can run this script during database installation if you know then that you will be doing direct loads. … create the necessary views. You need only run this script once for each

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Building IndexesYou can improve performance of direct path loads by using temporary storage. After each block is … Direct Path Loads\" for more information. When multiple indexes are built, the temporary segments … segment are removed. During a conventional path load, every time a row

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Indexes Left in an Unusable Statethat is in an Index Unusable state returns an error. The following conditions cause a direct path load

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Optimizing Performance of Direct Path LoadsYou can control the time and temporary storage used during direct path loads. To minimize time … Set DB_UNRECOVERABLE_SCN_TRACKING=FALSE. Unrecoverable (nologging) direct writes are tracked in the … control file by periodically storing the SCN and Time of the last direct write. If these updates to