Re: importing very large text file through SQLPLUS

Hi Bill

This is *not* the way to go :-) - have a look at sqlloader including using the direct path.

A Bientot
Marc

>Hello,
>
>I'd like to import a very large text file full of sql statements into
>sqlplus (~600mb). In mysql i can do it like so:
>cat theFile | mysql
>
>does something similiar like this exist in oracle? i've already tried
>the following:
>- start sqlplus
>- _at_theFile
>
>this takes *forever* -- anyway to do this faster?
>
>Thanks,
>--Bill
Received on Tue May 02 2000 - 00:00:00 CEST