Re: SQL Loader Help --

In article
<F4155D9F9AA4D111B9990020AFBA52D51E88BF_at_user62.sfi-software.com>,   "Dave Stienessen" <davids_at_xata.com> wrote:
> Hi,
> I'm trying to load data into oracle from a sql server bcp character
output
> file -- here's the specifics
>
> The error I receive is:
> SQL*Loader-524: partial record found at end of datafile
(oraclloadopts.txt)
>
> the table is defined as
> create table OrderProduct
> (
> OrderID NUMBER(6) not null,
> ShippingDate DATE not null,
> ProductID CHAR(10) not null,
> UnitPrice NUMBER(8,2) not null,
> Quantity INTEGER not null,
> )
>
> Here's my control file contents:
>
> OPTIONS (BINDSIZE=100000)
>
> LOAD DATA
> INFILE 'ORDERPRODUCT.TXT'
> BADFILE 'ORDERPRODUCT.BAD'
>
> INTO TABLE ORDERPRODUCT
> FIELDS TERMINATED BY ','
> -- hex code 27 is the single quote
> OPTIONALLY ENCLOSED BY X'27'
> (orderid, shippingdate DATE(23) "YYYY-MM-DD HH24:MI:SS", PRODUCTID,
> UNITPRICE,QUANTITY)
>
> Here's a sample record from the text file
> 78057,1976-04-15 07:44:12.000,' 0INT 0',656.37,5
>
> Does someone know what I'm doing wrong??
> Thanks
> Dave Stienessen
>
>

dave, try this
you need to include a linefeed (RETURN) at the end of the control file.

Manually go to the last line of your SQL*Loader controlfile and press ENTER to get to the next line. Once a new line is generated, SQL*Loader will read a record till the end and finish load. That may apply to both controlfile and datafile if datafile is generated through DOS.

Ted Chyn

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 22 1999 - 08:09:37 CDT