Re: SQL Loader Question

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

"Dagmar Anne Bogan" <dagmara_at_my-deja.com> wrote in message news:8ki7jg$onc$1_at_nnrp1.deja.com...
> I have a customer who purchased a COTS application that uses a
> centralized app server that will pick up files from locations across
> the US. These files will be ftped to the central server and will use
> SQL Loader to import. This entire process should not exceed 3 minutes.
>
> My SQL Loader questions:
>
> 1. Can multiple SQL Loader processes execute simultaneously?
Why not?
Though you probably shouldn't run them in direct mode as that bypasses the normal sql layer

> 2. If so, how will the table be locked? My concern is that even if
> multiple SQL Loader processes can be ran concurrently, will the table
> be updated serially?

Normal INSERT locks will be applied

> 3. If so, will each SQL Loader process create its own error file, or
> is there a risk of overwriting error records?
>

This depends on how clever your embedding script is. Also, IMO, you never should load your data in production tables *directly*, you should use 'technical' intermediate tables, without relational constraints. You will be able to exert more control with respect to the process.

> thanx!
> --
> Kopania & Komorovsky
> Specializing in Application Architecture and Design
>
> "Let's Stop Swatting Flies and Go After the Manure Pile"
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jul 12 2000 - 00:00:00 CDT