Data Load Error

Hi Oracle Guru's

I am getting error loading an ascii file on to a Oracle table. I am using sqlloader(Oracle 7.1).
(The ascii is a MS Access table exported as ascii)

The file has about 17000 records.

Only first 2579 rows gets loaded.

On 2580th row I get this error.

"ORA-01401: inserted value too large for column"

I checked the flat file, and the access table, 2579th and 2580th records both have very similar data, column sizesare enough to hold the data.I have 27 columns 22 are Varchar's, 3 are Number and 2 are date fields.

God! I dont know what's goin' on, damn SQl*Loader does not tell you which column is getting large value.

Somebody please help me sob! sob!.........

Thanx in Advance Kneel!...Kneel!............ Srini

Srinivas Mysore
Xerox Corp.
e-mail:srinivas_mysore_at_wb.xerox.com Received on Thu Jul 25 1996 - 00:00:00 CEST