Re: script , batch ..

From: Xavier Barau <Xavier.Barau_at_atosorigin.com>
Date: Mon, 22 Apr 2002 17:51:06 +0200
Message-ID: <aa3vum$qai$1@s1.read.news.oleane.net>

Thanks a lot for your answer.

Well the thing is , i cannot ask my customer to install sql*loader for the moment.
So should i divide the request in several one? So that my script would look like this:

Connect xx

Insert el_1 Into table
Insert el_2 Into table
Insert el_3 Into table

...
COMMIT
Disconnect ..

xavier

"Daniel Morgan" <damorgan_at_exesolutions.com> a écrit dans le message news: 3CC57952.539FC3B2_at_exesolutions.com...
> You need to use SQL*Loader which is the sqlldr executable in the
ORACLE_HOME/bin
> directory. To get information on using it go to http://technet.oracle.com
and
> search for 'SQL Loader'.
>
> Also, you will need to FTP the file to the local box to do this.
>
> Daniel Morgan
>
>
> Xavier Barau wrote:
>
> > As i 'm quite beginer in Oracle, i have few basics questions.
> > I have to generate scripts use to Insert 100 000 entries, from a text
file,
> > in a distant Oracle 8 database.
> > Where could i find samples with all the connect procedure and insert
> > request.
> > Thanks a lot
> > Xavier
>
Received on Mon Apr 22 2002 - 10:51:06 CDT