Re: using sql*loader from pl/sql

From: Prem K Mehrotra <premmehrotra_at_hotmail.com>
Date: 18 Nov 2004 13:53:39 -0800
Message-ID: <43441e77.0411181353.7956e080@posting.google.com>

DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1100759368.620747_at_yasure>...
> Howard J. Rogers wrote:
>
> > And where do you think this index will reside? In another text file? Or
> > inside the database.... and if inside the database, what is the point of
> > trying to keep the data itself OUT of the database?!
> >
> > Whatever...
> >
> > HJR
>
> Not to mention the concept of having a rowid that points to a particular
> block in a particular data file would have no meaning.

Oracle has to figure out someway. How does Oracle do a query today from external tables.

I think it will be nice to have some indexes, One can ofcourse use regular tables, but then again I have not found many uses of one time external table access. Received on Thu Nov 18 2004 - 15:53:39 CST