Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: New User and SQL*PLUS
I would suggest you look up documentation on SQL*Loader. This is specifically designed to take files of input and insert them into Oracle tables. Size of the records should not be an issue, but review the documentation on the RECLEN option. As far as performance options, make sure you review the documentation on the DIRECT PATH option.
Ben Salemi
Global Consulting Group
In article <3516FF69.6416_at_allensysgroup.com>,
jeffd <jeffd_at_allensysgroup.com> wrote:
>
> I need to input big records into SQL*PLUS. I have varchar columns
> of 1000+bytes. I don't know what the limit to a record (before <cr>) is
> and how to wrap data onto subsequent lines in the input file. Also, any
> performance hints for running my gigabyte input file would be
> appreciated.
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 24 1998 - 00:00:00 CST