Re: using sql*loader from pl/sql

From: Prem K Mehrotra <premmehrotra_at_hotmail.com>
Date: 14 Nov 2004 18:23:40 -0800
Message-ID: <43441e77.0411141823.e84dc22@posting.google.com>

DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1100456586.152756_at_yasure>...
> Kaly wrote:
>
> > is there any method to use sql*loader from pl/sql code?
> > i heard about doing it with java classes but i can't use it in my application
> >
> > thanx
> > kaly
>
> And your Oracle has a version?
>
> If 10g look at DBMS_SCHEDULER.
>
> Otherwise go to http://asktom.oracle.com for some solutions.
>
> If 9i or above I wouldn't waste my time with SQL*Loader and look at
> using external tables.

External tables are great but one limitation I found when I used in 9i is one cannot create any indexes on the external table. I don't know about 10G. So if I have loaded lot of data in an external table and later wanted to access it, my select will always be full table scan. Also, I cannot delete, insert, update using sql.

Prem Received on Sun Nov 14 2004 - 20:23:40 CST