Re: importing very large text file through SQLPLUS
From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/05/11
Message-ID: <shmrdknhkcp20_at_corp.supernews.com>#1/1
Date: 2000/05/11
Message-ID: <shmrdknhkcp20_at_corp.supernews.com>#1/1
"Bill Lynch" <bill_at_coolNOSPAMservlets.com> wrote in message
news:390E5118.9EC95EEA_at_coolNOSPAMservlets.com...
> 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
SQL*Loader.
-Matt Received on Thu May 11 2000 - 00:00:00 CEST