time for a coffee break?
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1067449363.351442_at_yasure...
> lfb wrote:
>
> >I'd like to fill my Oracle tables with content of various text files.
> >It seems that the BULK INSERT command does not exist with Oracle ?
> >
> >How could I import my datas ?
> >
> >Thanks,
> >Laurent.
> >
> >
> Seems like you made a statement about what exists in Oracle without
> bothering to read
> any documentation. Even a cursory look at http://tahiti.oracle.com and a
> search of the word
> "BULK", or opening any book from Oracle Press or O'Reilly on the
> subject would have
> kept you from posting what you did.
>
> Lets start at the beginning. Do you think Oracle is an entity unchanged
> by time and space?
> Do you think version and edition information unimportant?
>
> Assuming 9i you could use external tables.
>
> Assuming any version available during the current millenium you could
> use SQL*Loader
> with Direct Path.
>
> Do you truly believe we are building terabyte databases with insert
> statements one row
> at a time?
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Wed Oct 29 2003 - 12:51:25 CST
