Re: using sql*loader from pl/sql

Prem K Mehrotra wrote:

>
>
> 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.
>

BUT you can very, very easily transfer from the loading table to a live table using something a CTAS or insert from select.

Hopefully you are not using an external table as a permanent data source. The inefficiencies would be astounding!

/Hans Received on Sun Nov 14 2004 - 20:41:46 CST