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)

SQL*Loader Concepts

Conventional Path Loads, Direct Path Loads, and External Table LoadsSQL*Loader provides the following methods to load data: Conventional Path Loads Direct Path Loads External Table Loads

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

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

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

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

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

Direct Loads, Integrity Constraints, and Triggerssection discusses the implications of using direct path loads with respect to these features. … with the direct path, SQL*Loader disables some integrity constraints and all database triggers. This … With the conventional path load method, arrays of rows are inserted with standard SQL

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Loading ROWID ColumnsFigure 12-1 Database Writes on SQL*Loader Direct Path and Conventional Path Description of \"Figure … 12-1 Database Writes on SQL*Loader Direct Path and Conventional Path\" Loading ROWID Columns In … both conventional path and direct path,

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Advantages of a Direct Path Loadoption available during direct path loads enables you to presort data using high-performance sort … the SQL NOLOGGING parameter set See \"Instance Recovery and Direct Path Loads\". … A direct path load is faster than the conventional path

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Database Insert TriggersTable insert triggers are also disabled when a direct path load begins. After the rows are loaded … enabled. As a result, insert triggers do not fire for any rows loaded on the direct path. When using the … direct path, the application must ensure that any behavior associated with insert

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Using Direct Path LoadThis section explains how to use the SQL*Loader direct path load method.

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

When to Use a Direct Path LoadIf none of the previous restrictions apply, then you should use a direct path load when: You have a … large amount of data to load quickly. A direct path load can quickly load and index large amounts

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

Restrictions on Parallel Direct Path LoadsThe following restrictions are enforced on parallel direct path loads: Neither local nor global … disabled on parallel direct path loads. You do not have to take any action to disable them. SQL*Loader … is used If a parallel direct path load is being

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Restrictions on a Direct Path Load of a Single PartitionIn addition to the previously listed restrictions, loading a single partition has the following restrictions: The table that the partition is a member of cannot have any global indexes defined on it. Enabled referential and check constraints on the table that the partition is a member of are not allowed. Enabled triggers are not allowed.

Database Utilities, 11g Release 2 (11.2)

Conventional and Direct Path Loads

Specifying a Value for the Date CacheIf you are performing a direct path load in which the same date or timestamp values are loaded many … that require datatype conversion in order to be stored in the table The load is a direct path load … Date cache statistics are written to the log file. You can use those statistics to improve direct

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

Conventional Path Load of a Single PartitionBy definition, a conventional path load uses SQL INSERT statements. During a conventional path load