OraFAQ Forum: Server Utilities » ORA-01401: inserted value too large for column

Home » RDBMS Server » Server Utilities » ORA-01401: inserted value too large for column

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

ORA-01401: inserted value too large for column [message #163428]

Thu, 16 March 2006 13:28

AlinaC
Messages: 45
Registered: November 2005
Location: India

Member

set feedback off
set head off
spool d:\xx.dat
select a1||'~~~'||b1 from xx;
spool off

I have generated xx.dat from xx table, but when trying to load data into xx table of another server using sql Loader
getting error :

Record 102: Rejected - Error on table xx, column b1.
ORA-01401: inserted value too large for column

but column size is same of the xx table in both the servers.

ctl file -

LOAD DATA
INFILE 'xx'
BADFILE 'xx.bad'
DISCARDFILE 'xx.dsc'
APPEND
INTO TABLE xx
FIELDS TERMINATED BY '~~~'
TRAILING NULLCOLS
(a1 ,
b1 )

Please help.

Regards,

Alina

Report message to a moderator

Re: ORA-01401: inserted value too large for column [message #163431 is a reply to message #163428]

Thu, 16 March 2006 13:34

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

There is a difference in DDL of table in both databases.
Check whether they have been defined the same way.

Report message to a moderator

Re: ORA-01401: inserted value too large for column [message #163435 is a reply to message #163431]

Thu, 16 March 2006 13:56

AlinaC
Messages: 45
Registered: November 2005
Location: India

Member

The tables are defined same way. Even I have copied table from one server to another and then truncated table and tryed using sql loader.

Alina

Report message to a moderator

Re: ORA-01401: inserted value too large for column [message #163464 is a reply to message #163435]

Thu, 16 March 2006 16:04

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Using 10g?
I was able to reproduce the case only in 10g. 9i works fine.
seems '~' is the problem. It is been treated as new line.
Can you have any other delimters?

Report message to a moderator

Re: ORA-01401: inserted value too large for column [message #163731 is a reply to message #163464]

Sun, 19 March 2006 01:14

AlinaC
Messages: 45
Registered: November 2005
Location: India

Member

I'm using Oracle 9i. In Source and target database the size of the b1 filed is varchar2(16) not null. But if I increase the b1 filed of the target database to varchar2(20), Sql loader, loading data successfully. How it is possible? I'm inserting 1000 recors, how I verify whether, all records inserted successfully?

Pl. Help.

Regards,
Alina.

Report message to a moderator

Re: ORA-01401: inserted value too large for column [message #163738 is a reply to message #163731]

Sun, 19 March 2006 04:52

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

post your DDL,some sample data and your logfile.
As stated before, i was not able to reproduce your case.

Report message to a moderator

Previous Topic:	transportable tablespace error
Next Topic:	IMP Problem "the objects were exported by FINANCE, not by you"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 19:26:46 CDT 2024