OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL*LOADER Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: SQL*LOADER Error [message #232466 is a reply to message #232460]

Fri, 20 April 2007 11:30

Mahesh Rajendran
Messages: 10707
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 18 08:28:48 CDT 2024