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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL Loader Question

RE: SQL Loader Question

From: Ken Janusz <ken.janusz_at_sufsys.com>
Date: Thu, 10 Jan 2002 11:51:05 -0800
Message-ID: <F001.003ECF35.20020110110550@fatcity.com>

<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

>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
>   INET: kirti.deshpande_at_verizon.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_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).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>  This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-- 
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

Original text of this message

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