Home » RDBMS Server » Server Utilities » import error 1438
import error 1438 [message #265395] Thu, 06 September 2007 04:36 Go to next message
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..
Re: import error 1438 [message #265403 is a reply to message #265395] Thu, 06 September 2007 04:45 Go to previous messageGo to next message
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

icon5.gif  Re: import error 1438 [message #265408 is a reply to message #265403] Thu, 06 September 2007 04:57 Go to previous messageGo to next message
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..
Re: import error 1438 [message #265412 is a reply to message #265395] Thu, 06 September 2007 05:00 Go to previous messageGo to next message
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
Re: import error 1438 [message #265428 is a reply to message #265412] Thu, 06 September 2007 05:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: import error 1438 [message #265559 is a reply to message #265428] Thu, 06 September 2007 11:34 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Arju, Please watch your line size. Use "Preview Message" button.



Arrow
Re: import error 1438 [message #266941 is a reply to message #265559] Wed, 12 September 2007 01:13 Go to previous message
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
Previous Topic: records are not getting loaded in order in 10g ( 8i->10g)
Next Topic: EXP-00056 Oracle Error 6550 encountered
Goto Forum:
  


Current Time: Sat Dec 10 22:44:25 CST 2016

Total time taken to generate the page: 0.11638 seconds