Home » RDBMS Server » Server Utilities » SQL*LOADER Error
SQL*LOADER Error [message #232460] Fri, 20 April 2007 11:08 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10672
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

Previous Topic: IMP/EXP
Next Topic: Need to load .csv file into Oracle table.
Goto Forum:
  


Current Time: Tue Dec 06 15:57:24 CST 2016

Total time taken to generate the page: 0.12409 seconds