Re: I need to load in records from a text file.

In article <353B3EE8.7DD5_at_virgin.net>, John Taylor <john_hamilton.taylor_at_virgin.net> wrote:
> I have to load 68000 records from a text file which I can do by either
> using a stored procedure or an SQL statement, but as you can imagine
> this takes at least half an hour. Is there a better alternative?
> The best way seems to be to format the records into a way understandable
> by SQL*LOADER. However I do not have SQL*LOADER as it does not appear to
> ship with ORACLE 7 Workgroup Server (v 7.3.3.4.), so is there any other
> way, apart fron INSERT INTO, I can use to load 68000 records into a
> table quickly?

I do believe sqlloader ships with Oracle7. On my NT box, it's in the bin directory of my install && named slqldr73.exe; on my Sun workstation it's in $ORACLE_HOME/bin && named sqlload.

It's not avaliable from svrmgr{l,m}; try the command from a shell tool.

>
> Many Thanks for your help,
>
> John H. Taylor (john_hamilton.taylor_at_virgin.net)
Regards,
Gary

gary         -=-  The C Programmers' Reference  -=-
              http://www.gator.net/~garyg/C/c.html
        -=-  Avenue Programmers' Classes' Requests  -=-
             http://www.gator.net/~garyg/class.htm