How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Discontinued Direct Path Loads → In 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
Direct Path Loads → A 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
Conventional Path Loads, Direct Path Loads, and External Table Loads → SQL*Loader provides the following methods to load data: Conventional Path Loads Direct Path Loads External Table Loads
Restrictions on a Direct Path Load of a Single Partition → In 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.
Infrequent Data Saves → is 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 direct … path load. A small ROWS value can also result in wasted data block space because the last data block
Integrity Constraints → not 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
Intrasegment Concurrency with Direct Path → SQL*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
Restrictions on Parallel Direct Path Loads → The 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
PRIMARY KEY and UNIQUE KEY Constraints → subsequently can take a significantly long time to enable after a direct path loading session if the table
Conventional Path Load of a Single Partition → By definition, a conventional path load uses SQL INSERT statements. During a conventional path load
Direct Path Load of a Single Partition or Subpartition → subpartition 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
Loading into Synonyms → You can load data into a synonym for a table during a direct path load, but the synonym must point
Using Direct Path Load → This section explains how to use the SQL*Loader direct path load method.
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.
Increasing Performance with Concurrent Conventional Path Loads → consider 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
Parallel Data Loading Models → time required for data loading: Concurrent conventional path loads Intersegment concurrency with the … direct path load method Intrasegment concurrency with the direct path load method
Concurrent Conventional Path Loads → Performance 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
Parameters for Parallel Direct Path Loads → When 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
General Performance Improvement Hints → optimized 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
Data Loading Methods → direct 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