| SQL*Loder Problem [message #368323] |
Fri, 10 November 2000 23:31  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
