Re: using sql*loader from pl/sql

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 14 Nov 2004 21:34:26 -0800
Message-ID: <1100496787.510427@yasure>

Prem K Mehrotra wrote:

> 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

If you are importing the data indexes are useless as you will be doing a full table scan: One time only.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sun Nov 14 2004 - 23:34:26 CST