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

Home -> Community -> Mailing Lists -> Oracle-L -> SQL*Loader question

SQL*Loader question

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Wed, 6 Dec 2000 17:02:32 -0500
Message-Id: <10702.123857@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C05FD0.3BB418CE
Content-Type: text/plain;

        charset="iso-8859-1"

Hi everyone,

I know this has been discussed before. Below the controlfile is inserting a sequence number into a table along with the data. I'm very rusty with SQL*Loader. Does anyone see anything wrong with this control file? There is indeed a column for a sequence number primary key in this table.

Any suggestions are appreciated.
Thanks

>  -----Original Message-----
> From: 	Metzler, Larry  
> Sent:	Wednesday, December 06, 2000 4:58 PM
> To:	Koivu, Lisa
> Subject:	on my way over
> 
> 
> LOAD DATA 
> APPEND
> INTO TABLE load_rebate
> FIELDS TERMINATED BY ","
> (
> rec_no SEQUENCE(1,1),
> url_variable, 
> manu_part_number nullif manu_part_number = blanks,
> ingrammicro_sku nullif ingrammicro_sku=blanks,
> upc nullif upc=blanks,
> manufacturer nullif manufacturer = blanks,
> title nullif title = blanks,
> rebate filler,
> blargy filler,
> end_date,
> flargy filler)
> 
>  -----Original Message-----
> From: 	Koivu, Lisa  
> Sent:	Wednesday, December 06, 2000 4:28 PM
> To:	Naginsky, Irina; Metzler, Larry
> Subject:	
> 
> I should make you both buy me booze for making such a fool of me...  then
> again I guess I'm pretty gullible. 
> 
> Lisa Rutland Koivu
> Oracle Database Administrator
> Qode.com
> 4850 North State Road 7
> Suite G104
> Fort Lauderdale, FL  33319
> 
> V: 954.484.3191, x174
> F: 954.484.2933 
> C: 954.658.5849
> http://www.qode.com
> 
> "The information contained herein does not express the opinion or position
> of Qode.com and cannot be attributed to or made binding upon Qode.com."
> 

------_=_NextPart_001_01C05FD0.3BB418CE
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>SQL*Loader question</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Hi everyone, </FONT>
</P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">I know this has been =
discussed before.&nbsp; Below the controlfile is inserting a sequence = number into a table along with the data.&nbsp; I'm very rusty with = SQL*Loader. Does anyone see anything wrong with this control = file?&nbsp; There is indeed a column for a sequence number primary key = in this table. </FONT></P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Any suggestions are =
appreciated. </FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Thanks</FONT>
</P>

<P><FONT FACE=3D"r_ansi"></FONT>&nbsp;<FONT SIZE=3D1 =
FACE=3D"Tahoma">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Tahoma">From: &nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Tahoma">Metzler, Larry&nbsp; </FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Tahoma">Sent:&nbsp;&nbsp;</FONT></B> =
<FONT SIZE=3D1 FACE=3D"Tahoma">Wednesday, December 06, 2000 4:58 =
PM</FONT>
<BR><B><FONT SIZE=3D1 =

FACE=3D"Tahoma">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 = FACE=3D"Tahoma">Koivu, Lisa</FONT>
<BR><B><FONT SIZE=3D1 =

FACE=3D"Tahoma">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT= ></B> <FONT SIZE=3D1 FACE=3D"Tahoma">on my way over</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"r_ansi">LOAD DATA </FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">APPEND</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">INTO TABLE load_rebate</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">FIELDS TERMINATED BY =
&quot;,&quot;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">(</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">rec_no SEQUENCE(1,1),</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">url_variable, </FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">manu_part_number nullif =
manu_part_number =3D blanks,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">ingrammicro_sku nullif =
ingrammicro_sku=3Dblanks,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">upc nullif upc=3Dblanks,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">manufacturer nullif manufacturer =3D =
blanks,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">title nullif title =3D =
blanks,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">rebate filler,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">blargy filler,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">end_date,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"r_ansi">flargy filler)</FONT>
</P>
<UL>
<P><FONT FACE=3D"Arial"></FONT>&nbsp;<FONT SIZE=3D1 =
FACE=3D"Tahoma">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Tahoma">From: &nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Tahoma">Koivu, Lisa&nbsp; </FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Tahoma">Sent:&nbsp;&nbsp;</FONT></B> =
<FONT SIZE=3D1 FACE=3D"Tahoma">Wednesday, December 06, 2000 4:28 =
PM</FONT>
<BR><B><FONT SIZE=3D1 =

FACE=3D"Tahoma">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 = FACE=3D"Tahoma">Naginsky, Irina; Metzler, Larry</FONT>
<BR><B><FONT SIZE=3D1 =

FACE=3D"Tahoma">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</FONT></B>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">I should make you both buy me booze =
for making such a fool of me...&nbsp; then again I guess I'm pretty = gullible. </FONT>
</P>

<P><B><FONT SIZE=3D1 FACE=3D"Arial">Lisa Rutland Koivu</FONT></B>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Qode.com</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">4850 North State Road 7</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Suite G104</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Fort Lauderdale, FL&nbsp; =
33319</FONT>
</P>

<P><FONT SIZE=3D1 FACE=3D"Arial">V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">F: 954.484.2933 </FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">C: 954.658.5849</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial"><A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A></FONT>
</P>

<P><I><FONT COLOR=3D"#000000" SIZE=3D1 FACE=3D"Arial">&quot;The =
information contained herein does not express the opinion or position = Received on Wed Dec 06 2000 - 16:02:32 CST

Original text of this message

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