Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL Loader Question
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Ron:
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>That's
great, I'll give it a try.
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Thanks,
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Ken
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<font size=2 color=black
face=Tahoma>-----Original
Message-----
From: Ron Rogers
[mailto:RROGERS_at_galottery.org]
Sent: Thursday, January 10, 2002
12:23 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: SQL Loader Question
<span
style='font-size:12.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:1.5pt;margin-right:0in;margin-bottom:
0in;margin-left:37.5pt;margin-bottom:.0001pt'><font size=1 color=black
face="MS Sans Serif"><span style='font-size:7.5pt;font-family:"MS Sans Serif";
color:black'>Ken,<span
style='font-size:8.0pt;font-family:"MS Sans Serif";color:black;mso-color-alt:
windowtext'>
<font size=1 color=black
face="MS Sans Serif"><span style='font-size:7.5pt;font-family:"MS Sans Serif";
color:black'> You could create a batch file that references each par file
and then run the batch file.<font size=1 color=black
face="MS Sans Serif"><span style='font-size:8.0pt;font-family:"MS Sans Serif";
color:black;mso-color-alt:windowtext'>
<font size=1 color=black
face="MS Sans Serif"><span style='font-size:7.5pt;font-family:"MS Sans Serif";
color:black'>ex:<span
style='font-size:8.0pt;font-family:"MS Sans Serif";color:black;mso-color-alt:
windowtext'>
<font size=1 color=black
face="MS Sans Serif"><span style='font-size:7.5pt;font-family:"MS Sans Serif";
color:black'>file :testexp.bat contains the following lines;<font
size=1 color=black face="MS Sans Serif"><span style='font-size:8.0pt;
font-family:"MS Sans Serif";color:black;mso-color-alt:windowtext'>
<font size=1 color=black
face="MS Sans Serif"><span style='font-size:7.5pt;font-family:"MS Sans Serif";
color:black'>exp login/passwd_at_server
parfile=location and name of parfile1<font size=1 color=black
face="MS Sans Serif"><span style='font-size:8.0pt;font-family:"MS Sans Serif";
color:black;mso-color-alt:windowtext'>
<font size=1 color=black
face="MS Sans Serif"><span style='font-size:7.5pt;font-family:"MS Sans Serif";
color:black'>exp login/passwd_at_server
parfile=location and name of parfile2<font size=1 color=black
face="MS Sans Serif"><span style='font-size:8.0pt;font-family:"MS Sans Serif";
color:black;mso-color-alt:windowtext'>
<font size=1 color=black
face="MS Sans Serif"><span style='font-size:7.5pt;font-family:"MS Sans Serif";
color:black'>etc.<span
style='font-size:8.0pt;font-family:"MS Sans Serif";color:black;mso-color-alt:
windowtext'>
<font size=1 color=black
face="MS Sans Serif"><span style='font-size:7.5pt;font-family:"MS Sans Serif";
color:black'>then just execute the testexp.bat file.<font size=1
color=black face="MS Sans Serif"><span style='font-size:8.0pt;font-family:"MS Sans Serif";
color:black;mso-color-alt:windowtext'>
<font size=1 color=black
face="MS Sans Serif"><span style='font-size:7.5pt;font-family:"MS Sans Serif";
color:black'>Works good under Novell.<font size=1 color=black
face="MS Sans Serif"><span style='font-size:8.0pt;font-family:"MS Sans Serif";
color:black;mso-color-alt:windowtext'>
<font size=1 color=black
face="MS Sans Serif"><span style='font-size:7.5pt;font-family:"MS Sans Serif"; color:black'>ROR mª¿ªm<font size=1 color=black face="MS Sans Serif"><span style='font-size:8.0pt;font-family:"MS Sans Serif";color:black;mso-color-alt:windowtext'>
<font size=1 color=black
face="MS Sans Serif"><span style='font-size:8.0pt;font-family:"MS Sans Serif";
color:black'>
>>> adary_at_mehish.co.il 01/10/02 11:50AM >>> I tested under 8.1.6 on NT and the reply is NO. Checked also the new features for 9.0.1 and no mention of this.
Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il
> -----Original Message-----
> From: Deshpande, Kirti
[SMTP:kirti.deshpande_at_verizon.com]
> Sent: Thu, January 10, 2002 4:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQL Loader Question
>
> My guess is : No.
> Can you run a quick test and let us know ??
> Thanks.
> - Kirti
>
> -----Original Message-----
> Sent: Wednesday, January 09, 2002 3:45 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 8.1.7 on W2000
> I would like to know if there is a way to group more than one parfile into
> one file? I would like to run just one file verses a number of
parfiles.
>
> Thanks,
> Ken Janusz, CPIM
> Database Conversion Lead
> Sufficient Systems, Inc.
> Minneapolis, MN
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
> INET: ken.janusz_at_sufsys.com
> INET: kirti.deshpande_at_verizon.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: adary_at_mehish.co.il 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_at_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).<font size=1 color=black face="MS Sans Serif"><span style='font-size:8.0pt; font-family:"MS Sans Serif";color:black;mso-color-alt:windowtext'>Received on Thu Jan 10 2002 - 13:51:05 CST