OraFAQ Forum: Server Utilities » import error 1438

Home » RDBMS Server » Server Utilities » import error 1438

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

import error 1438 [message #265395]

Thu, 06 September 2007 04:36

phani_nam
Messages: 2
Registered: September 2007
Location: VISAKHAPATNAM

Junior Member

hi, i am getting ora-1438 error
value too large for precision when importing a cold backup into 9i database..
the source and target databases are same and block sizes are also same ..
can any body help me regarding this..

Report message to a moderator

Re: import error 1438 [message #265403 is a reply to message #265395]

Thu, 06 September 2007 04:45

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

ORA-01438:	value larger than specified precision allowed for this column
Cause:	When inserting or updating records, a numeric value was 
entered that exceeded the precision defined for the column.

Action:	Enter a value that complies with the numeric column's 
precision, or use the MODIFY option with the ALTER TABLE command
 to expand the precision.

[Updated on: Thu, 06 September 2007 05:32]

Report message to a moderator

Re: import error 1438 [message #265408 is a reply to message #265403]

Thu, 06 September 2007 04:57

phani_nam
Messages: 2
Registered: September 2007
Location: VISAKHAPATNAM

Junior Member

thank u arju, but my database has crashed and it has to be restored by importing it.and i am getting this record while importing .so, will u please help me how can i import without this error..

Report message to a moderator

Re: import error 1438 [message #265412 is a reply to message #265395]

Thu, 06 September 2007 05:00

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You can simply ignore this error for now.
As you have export dump file and you can't change in it. So while importing use ignore=y

Report message to a moderator

Re: import error 1438 [message #265428 is a reply to message #265412]

Thu, 06 September 2007 05:31

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Arju, Please watch your line size. Use "Preview Message" button.

phani_nam, you surely change your character set when recreating the database (switch to %UTF8). Keep the same character set as in previous db.

By the way, export is not a backup strategy and It can't be done offline (so can't be cold).

Regards
Michel

Report message to a moderator

Re: import error 1438 [message #265559 is a reply to message #265428]

Thu, 06 September 2007 11:34

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

Arju, Please watch your line size. Use "Preview Message" button.

Report message to a moderator

Re: import error 1438 [message #266941 is a reply to message #265559]

Wed, 12 September 2007 01:13

d.c.b.a
Messages: 44
Registered: March 2005
Location: China

Member

Maybe due to the NLS_LANG setting.

Or the character set is different between the source and target databases.

Good tools make work easy and improve life quality.
http://www.dbatools.net

Report message to a moderator

Previous Topic:	records are not getting loaded in order in 10g ( 8i->10g)
Next Topic:	EXP-00056 Oracle Error 6550 encountered

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 14:23:14 CST 2025