Home » RDBMS Server » Server Utilities » SQL*Loder Problem
SQL*Loder Problem [message #368323] Fri, 10 November 2000 23:31 Go to next message
Hari
Messages: 59
Registered: August 2000
Member
Hi,
Iam trying to insert data into a table from text file using the following control file..(Iam giving a part of the .ctl file coz there r 300 fields in it)

LOAD DATA
INFILE 'ak99agn.dat'
APPEND
INTO TABLE sch_scdis99_00
(
LEAID POSITION (0001:0007) CHAR,
STID99 POSITION (0008:0021) CHAR,
NAME99 POSITION (0022:0081) CHAR,
PHONE99 POSITION (0082:0091) CHAR,
MSTREE99 POSITION (0092:0121) CHAR,
MCITY99 POSITION (0122:0151) CHAR,
MSTATE99 POSITION (0152:0153) CHAR,
)
should i keep coma at the last line in control file(as above)??

it is giving the following error
Record 1: Rejected - Error on table SCH_SCDIS99_00.
ORA-01401: inserted value too large for column

The main problem here is...
1.First i have created a table with some feild length(VARCHAR2(10)),Here 785 rows r inserted and 51 rows r rejected.

2.Again i have created a new table with increased field length(VARCHAR(20)),Here 338 rows r inserted and 51 rows r rejected.

In both the cases the same .dat file is used.

Why the inserted rows r different in both the cases??
Re: SQL*Loder Problem [message #368324 is a reply to message #368323] Sat, 11 November 2000 14:42 Go to previous message
Neeraja
Messages: 8
Registered: November 2000
Junior Member
you cannot have the comma before the ). The first time the data in the flat flat for some of the columns exceeded the length of the field.
Previous Topic: access tables to oracle
Next Topic: Urgent - Exporting Data to Flat file
Goto Forum:
  


Current Time: Thu Mar 28 15:44:12 CDT 2024