Tony,
I think you're missing the key word "append".
(This is from UNIX so your mileage may vary slightly <g>, but it works)
LOAD DATA
INFILE 'BLAH.TXT'
BADFILE 'BLAH.BAD'
DISCARDFILE 'BLAH.DSC'
APPEND INTO TABLE BLAH_T
(
<COLUMNINFO...>
)
HTH
Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA 94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[EMAIL PROTECTED]
-----Original Message-----
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 10:29 PM
To: CF-Talk
Subject: Re: [Quick (Maybe) Oracle SQL*Loader Question]
I'm loading into an empty table
CTL File:
LOAD DATA
INFILE 'e:\LVI\VRA8.txt'
INTO TABLE AudioFile
(
ActionCode POSITION(1:2),
ChangeDate POSITION(3:10),
ChangeTime POSITION(11:16),
LabelNumber POSITION(17:21),
CatalogNumber POSITION(22:28),
ConfigNumber POSITION(29:29),
ArtistName POSITION(30:59),
ItemTitle POSITION(60:89),
ItemDesc1 POSITION(90:119),
ItemDesc2 POSITION(120:149),
UPC POSITION(150:162),
UPCExt POSITION(163:167),
LabelAbbr POSITION(168:171),
LabelName POSITION(172:201),
SupplierNumber POSITION(202:211),
RetailPrice POSITION(212:220),
CostPrice POSITION(221:229),
SupplierPriceCode POSITION(230:233),
SupplierPrefix POSITION(234:237),
StreetDate POSITION(238:245),
ReceiptDate POSITION(246:253),
DiscontinueDate POSITION(254:261),
LastReturnDate POSITION(262:269),
LastOrderDate POSITION(270:277),
ValleyCat1 POSITION(278:282),
PriorityNumber POSITION(283:285),
ConfigExt POSITION(286:288),
GeneralCat POSITION(289:293),
LinkID POSITION(294:305),
PurchasePrice POSITION(306:314),
SalesQty POSITION(315:325),
FullCasePack POSITION(326:328),
PermanentID POSITION(329:345),
ValleyCat2 POSITION(346:350)
)
> post you *.ctl file
> also i think you have to append when you load.
>
>
> Tony Schreiber <[EMAIL PROTECTED]> wrote:
> I'm importing a file into a new table. It's a fixed width text file for
> which I've created a load control file that works. (I've gone through
> several revisions to get one without errors ;p ) I setup the load with
> Data Manager and it runs successfully, the log file says 297,XXX records
> (big file) imported without error. So what's the problem?...
>
> There's nothing in the table! If I select all or select count(), I get
> nothing. Zip. Zero. Nada. What am I doing wrong? I'm using the same db,
> same table, same user...
>
>
>
> Tony Schreiber, Senior Partner Man and Machine, Limited
> mailto:[EMAIL PROTECTED] http://www.technocraft.com
>
> http://www.linktoss.com _______The Fastest Way to Send a Link to Anyone!
> http://www.digitacamera.com ______________DigitA Camera Scripts and Tips
> http://www.is300.net ___________The Enthusiast's Home of the Lexus IS300
> http://www.cfug-sfl.org ___________South Florida Cold Fusion Users Group
> http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
