Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Loader problem

Re: SQL*Loader problem

From: Charlie Edwards <charlie3101_at_hotmail.com>
Date: 10 Dec 2002 02:01:56 -0800
Message-ID: <217ac5a8.0212100201.3dda2e89@posting.google.com>

damorgan <damorgan_at_exesolutions.com> wrote in message news:<3DF4CF6E.AD0B508_at_exesolutions.com>...

> If it is "hundreds of records" I'd throw SQL*Loader away and just write a small procedure with
> UTL_FILE. There is nothing SQL*Loader can do that UTL_FILE can't do better except through-put.
>
> Daniel Morgan

So would I, but unfortunately, the standard method imposed upon me by the DBA (for consistency etc) is to use SQL*Loader. Similarly, ALL job scheduling HAS to be done using cron - I am not permitted to use DBMS_JOB! Ah well, just have to hope things don't go wrong, I guess :-(((

CE Received on Tue Dec 10 2002 - 04:01:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US