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 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

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 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

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

Conventional and Direct Path Loads

Infrequent Data Savesis not written to after a save, even if the data block is not full. Because direct path loads can … Frequent data saves resulting from a small ROWS value adversely affect the performance of a directpath load. A small ROWS value can also result in wasted data block space because the last data block

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

Integrity Constraintsnot enforce this rule. Thus, if subsequent direct path loads are performed with invalid data, the … During a direct path load, some integrity constraints are automatically disabled. Others are not … Oracle Database Advanced Application Developer's Guide. Enabled Constraints During a direct

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

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

PRIMARY KEY and UNIQUE KEY Constraintssubsequently can take a significantly long time to enable after a direct path loading session if the table

Database Utilities, 11g Release 1 (11.1)

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

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

Direct Path Load of a Single Partition or Subpartitionsubpartition direct path loads. During a direct path load of a single partition, SQL*Loader uses the … , and direct path loads of, other partitions in the table. Although a direct path load minimizes

Database Utilities, 11g Release 1 (11.1)

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

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

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

Increasing Performance with Concurrent Conventional Path Loadsconsider using concurrent conventional path loads. That is, use multiple load sessions executing … boundaries, and then load each such input datafile with a conventional path load session. The resulting … system, but probably not as fast as a direct load. Triggers fire, integrity constraints are applied to

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

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

Database Utilities, 11g Release 1 (11.1)

Conventional and Direct Path Loads

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

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

Data Loading Methodsdirect path loads, such as restrictions, security, and backup implications, are discussed in this … path loads perform database writes. Figure 11-1 Database Writes on SQL*Loader Direct Path and … SQL*Loader provides two methods for loading data: Conventional Path