Re: Any free script/utility for bulk loading using SQLLoader
From: Pawan <pawanputrahanuman_at_yahoo.com>
Date: 28 May 2003 15:30:57 -0700
Message-ID: <84857442.0305281430.1f21d08f_at_posting.google.com>
Date: 28 May 2003 15:30:57 -0700
Message-ID: <84857442.0305281430.1f21d08f_at_posting.google.com>
If you are using Oracle then the best(fast and Simple) would be to use Direct Path Load using SQL Loader. Disable Indexes and constraints if you are certain that the data is reliable and after loading using SQL*loader rebuild the indexes using UNRECOVERABLE (and maybe even parallel).
Hope this helps.
I hate committing in a cursor for loop -- wastes resources, takes
longer,
generally inefficient.
avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<25c1993e.0305271132.703ac7ae_at_posting.google.com>...
> Hi folks,
>
> Is there any free sql script / unix/perl script that reads ascii flat
> files and does a bulk load using sql loader.
>
> -thx,
> avsrk
Received on Thu May 29 2003 - 00:30:57 CEST