Re: Faster loading with SQL*Loader

Amir Farhi <phantom_at_math.tau.ac.il> wrote:

>Hi Edwin,
 

> Oracle SQL*Loader has a geat feature called the "Direct Loader". This
> enabled you to load record very fast.
 

> In order to execute the SQL*Loader with the Direct option enabled jusr
> specipy "DIRECT=YES" on your command line, and see for yourself.
 

> There is one limiation to that: You are not allowed to use function in
> your CTL file.
 

> Another parameter, which enhances performance, is the "PARALLEL=YES",
> which will use several processors (if available on SMP machines).
 

>Good Luck

There are a few other limitations to direct path loads.

1. They can't be used on clustered tables.
2. Table insert triggers never fire for direct path loads. This can be a problem if the table you're loading is going to be snapshotted and has a snapshot log on it. The log will never show the new rows.
3. The table being loaded can't have any active transactions on it.
4. There can't be any active SELECTs on the table if the table is indexed. -- Chuck Hamilton chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself! Received on Fri Dec 29 1995 - 00:00:00 CET