Re: sqlloader on NT

From: Frank Zekert <zekert_at_wmd.de>
Date: Fri, 14 Aug 1998 14:31:02 +0200
Message-ID: <6r1an5$g3m$1@ns2.dokumenta.de>

Hi!
Go and get ORACLE patch 8.0.4.2 from ORACLE support. It is exactly the same problem that cost me 1/2 a day before finding this to be a GENERIC bug in 8.0.4 ! The problem occurs (I quote from the patch's README), when SQL*LOADER tries to write a record bigger than 270 byte to the *.bad or *.dis files. Obviously, ORACLE only uses very small records for it's test cases ;-)
I'm shure this patch will help: I've just tested it...

Frank

sshealy_at_asgnet.psc.sc.edu schrieb in Nachricht <6qpp6r$e98$1_at_nnrp1.dejanews.com>...
>I am familiar with using SQL Loader on a UNIX platform but not on NT. I am
>trying to load data in ORACLE 8.0 on NT 4.0 SP3 and am getting the
following
>error
>
>SQL*Loader-523: Error -2 writing to file(datafile.bad)
>
>I have checked to make sure that I have permission in the diretory and
>everything. I delete the bad file before trying again but it still won't
>work. BTW I am using the command line.
>
>Any idea why I am getting this error?
>
>Thanks
>Scott
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Aug 14 1998 - 07:31:02 CDT