Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: New User and SQL*PLUS

Re: New User and SQL*PLUS

From: Richard Ji <guile_at_escape.com>
Date: 1998/03/28
Message-ID: <351c4144.24310596@newshost.us.oracle.com>#1/1

On Mon, 23 Mar 1998 16:33:45 -0800, 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.

For gigabytes input, I would suggest use sql*loader using direct path. Received on Sat Mar 28 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US