SQL*LOADER Error [message #232460] |
Fri, 20 April 2007 11:08 |
world.apps
Messages: 70 Registered: January 2007 Location: Hyderabad
|
Member |
|
|
Hi
I am trying to execute the sql*loader by using fallowing control file.
load data
infile *
replace
into table departments
( deptno position (02:05) char(4),
dname position (06:20) char(15),
ddate position (21:31) char(11)
)
begindata
20 COMPUTER 03-apr-07
30 ENGLISH 05-apr-07
50 POLITICAL 07-apr-07
I am getting error in my log file like this:
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
DEPTNO 2:5 4 CHARACTER
DNAME 6:20 15 CHARACTER
DDATE 21:31 11 CHARACTER
Record 1: Rejected - Error on table DEPARTMENTS, column DNAME.
ORA-01401: inserted value too large for column
Record 2: Rejected - Error on table DEPARTMENTS, column DNAME.
ORA-01401: inserted value too large for column
Record 3: Rejected - Error on table DEPARTMENTS, column DNAME.
ORA-01401: inserted value too large for column
The fallowing one is the my departments table strucure:
SQL> desc departments;
Name Null? Type
------------------------------- -------- ----
DEPTNO NUMBER(2)
DNAME VARCHAR2(14)
DDATE DATE
Could you help me in this
Thanks in advance
|
|
|
Re: SQL*LOADER Error [message #232466 is a reply to message #232460] |
Fri, 20 April 2007 11:30 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Your positioning is not correct.
Blanks may have changed while you are posting on web.
Just play different settings.
oracle@mutation#cat dept1.ctl
load data
infile *
truncate
into table dept1
( deptno position (01:02) ,
dname position (05:13) ,
ddate position (17:26)
)
begindata
20 COMPUTER 03-apr-07
30 ENGLISH 05-apr-07
50 POLITICAL 07-apr-07
oracle@mutation#sqlldr scott/tiger control=dept1.ctl
SQL*Loader: Release 9.2.0.8.0 - Production on Fri Apr 20 12:32:27 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Commit point reached - logical record count 3
oracle@mutation#query mutation scott.dept1
DEPTNO DNAME DDATE
---------- -------------- ---------
20 COMPUTER 03-APR-07
30 ENGLISH 05-APR-07
50 POLITICAL 07-APR-07
[Updated on: Fri, 20 April 2007 11:31] Report message to a moderator
|
|
|