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 573 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Utilities, 11g Release 1 (11.1)

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 1 (11.1)

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 … error occurred. If there are multiple INTO TABLE statements in the control file, SQL*Loader loads

Database Utilities, 11g Release 1 (11.1)

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 1 (11.1)

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 1 (11.1)

Conventional and Direct Path Loads

Minimizing Use of the Redo Log… Disabling Archiving If archiving is disabled, direct path loads do not generate full image redo. Use … 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 redo log.

Database Utilities, 11g Release 1 (11.1)

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 1 (11.1)

Conventional and Direct Path Loads

Intrasegment Concurrency with Direct PathSQL*Loader permits multiple, concurrent sessions to perform a direct path load into the same table … performance of a direct path load given the available resources on your system. This method of data loading … as a parallel direct path load. It is important to realize that parallelism

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

General Performance Improvement Hintsoptimized if all character sets are the same. For direct path loads, it is best if the datafile … conversion buffers are not allocated. Use direct path loads. Use the SORTED INDEXES clause. Avoid … clause associated with it for every row loaded. Use parallel direct path

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

Conventional Path Loadfill them on each insert. Although appropriate during normal use, this can slow bulk loads dramatically. 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

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

Integrity ConstraintsAll integrity constraints are enforced during direct path loads, although not necessarily at the … constraints, are disabled before the direct path load and must be reenabled afterwards. If REENABLE is … error log. See Direct Loads, Integrity Constraints, and Triggers.

Database Utilities, 11g Release 1 (11.1)

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 1 (11.1)

Conventional and Direct Path Loads

Specifying a Direct Path LoadDirect Path Loads for information about parameters you can use to optimize performance of direct pathloads Optimizing Direct Path Loads on Multiple-CPU Systems if you are doing a direct path load on a multiple-CPU

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

Specifying the Number of Column Array Rows and Size of Stream Buffersnumber of column array rows and size of the steam buffer when you perform direct path loads on … multiple-CPU systems. See Optimizing Direct Path Loads on Multiple-CPU Systems for more information. … rows. Note that when VARRAY s are loaded using direct path,

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

Parallel Data Loading Modelstime required for data loading: Concurrent conventional path loads Intersegment concurrency with the … direct path load method Intrasegment concurrency with the direct path load method

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

Restrictions on Parallel Direct Path LoadsThe following restrictions are enforced on parallel direct path loads: Neither local nor global … stored as LOBs (such as VARRAYs). If a parallel direct path load is being applied to a single … (this is due to the individual loads not being coordinated). If you must truncate a table

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

Enabling Constraints After a Parallel Direct Path LoadSQL*Loader session can attempt to reenable constraints on a table after a direct path load, there is … that some constraints might not be reenabled after a direct path load, you should check the status of

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

11 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 covered: Data Loading Methods Conventional Path

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

Direct Path Loadwith I/O increases load performance. See Also: Discontinued Direct Path Loads … statement, a direct path load uses the direct path API to pass the data to be loaded to the load engine … direct path load engine uses the column array structure

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

Restrictions on Using Direct Path Loadsduring the load. This is because in direct path loads there is no SQL being generated to fetch the … The following conditions must be satisfied for you to use the direct path load method: Tables are … . For versions of the database prior to Oracle9 i, you can perform a SQL*Loader direct

Database Utilities, 11g Release 1 (11.1)

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.