Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g3SMbLL15863 for ; Sun, 28 Apr 2002 18:37:21 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id PAA41022; Sun, 28 Apr 2002 15:42:12 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 00451801; Sun, 28 Apr 2002 15:03:18 -0800 Message-ID: Date: Sun, 28 Apr 2002 15:03:18 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Eriovaldo Andrietta" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Eriovaldo Andrietta" Subject: Re: sqlldr Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0009_01C1EEE7.82FA91C0" ------=_NextPart_000_0009_01C1EEE7.82FA91C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ok Yechiel. Thanks for the answer. Regards=20 Eriovaldo ----- Original Message -----=20 From: Yechiel Adar=20 To: Multiple recipients of list ORACLE-L=20 Sent: Sunday, April 28, 2002 6:43 AM Subject: Re: sqlldr Hello I do not have experience with 9i and 8i. One paper that I downloaded from OTN (I think) is: Install and = Configure the Oracle 9i Platform. This paper starts with preinstall task: Remove installed oracle = databases and removed all installed oracle software from the machine.=20 I believe this is just to simplify the new install. We have a NT server with oracle 7.3.4 and 8.1.6 installed in two homes = and there are no problems. Yechiel Adar Mehish ----- Original Message -----=20 From: Eriovaldo Andrietta=20 To: Multiple recipients of list ORACLE-L=20 Sent: Sunday, April 28, 2002 2:13 AM Subject: Re: sqlldr HI Yechiel : How can i to install two versions of Oracle in the same server , = like : Oracle 8i and Oracle 9i, in oracle_home different. Is it possible ? Regards Eriovaldo=20 ----- Original Message -----=20 From: Yechiel Adar=20 To: Multiple recipients of list ORACLE-L=20 Sent: Saturday, April 27, 2002 8:18 PM Subject: Re: sqlldr Hello Stephen Thanks for the link. The article is very illuminating. As we have some loader tuning to do I thank you for sharing the = knowledge. Yechiel Adar Mehish ----- Original Message -----=20 From: Stephen Andert=20 To: Multiple recipients of list ORACLE-L=20 Sent: Friday, April 26, 2002 6:43 PM Subject: Re: sqlldr Ravi, =20 To the best of my knowledge, there is no limitation on the = number of records that can be loaded at a time other than the size of = your rollback segments. I have loaded 10's of millions of rows in a = single sqlldr job by setting some parameters. There are defaults that = work, but don't perform very well. To determine appropriate settings, = you may want to read an article I wrote for O'Reilly & Associates = (located at http://oracle.oreilly.com/news/oraclesqlload_0401.html) = which gives the step-by-step directions on setting 2 of the key = parameters (BINDSIZE and ROWS). It's a pretty easy thing to do, but = without knowing you data, the only advice I could give is that DIRECT is = the best quick tuning fix if you can. If you are going to be doing any serious data loading with = SQL*Loader, Jonathan's book Oracle SQL*Loader: The Definitive Guide = would be a good investment. HTH Stephen >>> ravindra@navin.com 04/25/02 10:13PM >>> i belive there is a limitation on the number of records that can = be loaded from sqlldr at a time based on the bind array and rows default = parameter. if i have a data file with more than 5000records(don't know the = exact number) that needs to be imported using sqlldr what is the value i need to set for the "rows" and/or "bind = array" for me to load the records to the table at one attempt. thanks ravi --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 Author: Ravindra B INET: ravindra@navin.com Fat City Network Services -- (858) 538-5051 FAX: (858) = 538-5051 San Diego, California -- Public Internet access / Mailing = Lists = -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail = message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and = in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You = may also send the HELP command for other information (like = subscribing). ------=_NextPart_000_0009_01C1EEE7.82FA91C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
ok Yechiel.
Thanks for the answer.
 
Regards
 
Eriovaldo
 
----- Original Message -----
From:=20 Yechiel=20 Adar
Sent: Sunday, April 28, 2002 = 6:43=20 AM
Subject: Re: sqlldr

Hello
 
I do not have experience with 9i and=20 8i.
One paper that I downloaded from OTN = (I think)=20 is: Install and Configure the Oracle 9i Platform.
This paper starts with preinstall = task: Remove=20 installed oracle databases and removed all installed oracle=20 software
from  the machine.
I believe this is just to simplify = the new=20 install.
We have a NT server with oracle 7.3.4 = and 8.1.6=20 installed in two homes and there are no problems.
 
Yechiel Adar
Mehish
----- Original Message -----
From:=20 Eriovaldo=20 Andrietta
To: Multiple=20 recipients of list ORACLE-L
Sent: Sunday, April 28, 2002 = 2:13=20 AM
Subject: Re: sqlldr

 
HI Yechiel :
 
How can i to install two versions = of Oracle in=20 the same server , like :
 
Oracle 8i and Oracle 9i, in = oracle_home=20 different.
 
Is it possible ?
 
Regards
 
Eriovaldo
 
 
----- Original Message ----- =
From:=20 Yechiel Adar
To: Multiple=20 recipients of list ORACLE-L
Sent: Saturday, April 27, = 2002 8:18=20 PM
Subject: Re: sqlldr

Hello Stephen
 
Thanks for the link.
The article is very=20 illuminating.
As we have some loader tuning to = do I thank=20 you for sharing the knowledge.
 
Yechiel Adar
Mehish
----- Original Message ----- =
From:=20 Stephen Andert
To: Multiple=20 recipients of list ORACLE-L
Sent: Friday, April 26, = 2002 6:43=20 PM
Subject: Re: sqlldr

Ravi,
 
To the best of my knowledge, there is no = limitation on=20 the number of records that can be loaded at a time other than = the size=20 of your rollback segments. I have loaded 10's of millions of = rows in a=20 single sqlldr job by setting some parameters.  There are defaults that work, but don't perform very = well. =20 To determine appropriate settings, you may want to read an = article I=20 wrote for O'Reilly & Associates (located at http://or= acle.oreilly.com/news/oraclesqlload_0401.html) which=20 gives the step-by-step directions on setting 2 of the key=20 parameters (BINDSIZE and ROWS).  It's a pretty easy thing = to do,=20 but without knowing you data, the only advice I could give is = that=20 DIRECT is the best quick tuning fix if you can.
 
If you are going to be doing any serious data loading with=20 SQL*Loader, Jonathan's book Oracle = SQL*Loader:=20 The Definitive Guide would be a good investment.
 
HTH
Stephen

>>> ravindra@navin.com 04/25/02 = 10:13PM=20 >>>
i belive there is a limitation on the number of = records=20 that can be loaded
from sqlldr at a time based on the bind = array and=20 rows default parameter.
if i have a data file with more than=20 5000records(don't know the exact
number) that needs to be = imported=20 using sqlldr
what is the value i need to set for the "rows" = and/or=20 "bind array" for me to
load the records to the table at one=20 attempt.

thanks
ravi

--
Please see the = official=20 ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Ravindra B
  INET: = ravindra@navin.com

Fat=20 City Network Services    -- (858) 538-5051  = FAX:=20 (858) 538-5051
San Diego,=20 California        -- Public = Internet=20 access / Mailing=20 = Lists
----------------------------------------------------------------= ----
To=20 REMOVE yourself from this mailing list, send an E-Mail = message
to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and = in
the=20 message BODY, include a line containing: UNSUB ORACLE-L
(or = the name=20 of mailing list you want to be removed from).  You = may
also send=20 the HELP command for other information (like=20 = subscribing).

------=_NextPart_000_0009_01C1EEE7.82FA91C0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: eca@siteplanet.com.br Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).