Oracle Error 1438 Encountered
Sidhu Errors are not really a welcome stuff😉 . Yesterday, I was importing a dump file (from 8.1.7.4) into 10.2.0.3 and hit IMP-00020: long column too large for column buffer size (number). After doing some googling and searching on metalink came to know (not sure though) that it was some bug in 8.1.7.4. And the solution was to try with different values of buffer parameter in import (which actually didn't help) . Thats what oerr also has to say: *Cause: The column buffer is too small. This usually occurs when importing LONG data. *Action: Increase the insert buffer size 10,000 bytes at a time (for example). Use this step-by-step approach because a buffer size that is too large may cause a similar problem. And also probably the issue was that the export was run with compress=N. So the guys again ran the export of the table with compress=Y (which is the default). Hopes got some oxygen and we again ran the import. That IMP-00020 was gone and a new baby struck: IMP-00058:Oracle Error 1438 encountered. ORA-01438:Value Larger Than Specified precision allow for this Column Again started the googling and metalink'ing session and found that it was some bug😦 . Import itself creating the table and then uttering ORA-01438. Complete non-sense. Isn't it ? Just hitting and trying what we did was pre-created the table with all the NUMBER columns having their data types defined simply as NUMBER without any precision and wow it completed without any errors. Now its stupid seriously. So then we did some research on the data in the table and found that there was one row which was causing the whole shit. There were two columns defined as NUMBER(12) but the values in them were of length 30 and 60. So what it was ? Probably a data corruption or what ? Otherwise how the table definition would have allowed such crap to enter the table. Couldn't ascertain the exact reason but happy ending, it was😉 Like this:Like Loading... Related Posted in Troubleshooting | Tagged imp-00020, imp-00058, ora-01438, oracle 8.1.7.4 | Leave a Comment Comments RSS Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. September 2008 M T W T F S S « Aug Oct » 1234567 891011121314 15161718192021 22232425262728 2930 Archive
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please https://community.oracle.com/thread/2424873?start=15&tstart=0 enter a title. You can not post a blank message. Please type your message and try again. More discussions in Globalization Support All PlacesDatabaseOracle Database + OptionsGlobalization Support This discussion http://itnewscast.com/imp00058oracle-error-1438-encountered-0 is archived 1 2 Previous Next 16 Replies Latest reply on Aug 10, 2012 7:36 PM by user10674190 Go to original post This content has been marked as final. Show oracle error 16 replies 15. Re: Import error: ORA-01438 orafad Aug 8, 2012 10:00 PM (in response to user10674190) To continue investigation of original issue, i.e. When try to import to Oracle11g, I got ORA-01438 on OT table: . . importing table "OT" IMP-00058: ORACLE error 1438 encountered ORA-01438: valor maior que a precisão especificada usado para esta colunaAs Sergiusz suggests earlier, you oracle error 1438 have not narrowed this down yet. Running a trace while importing the table in question may be helpful in finding the offending statement, value, etc. Also none of the previous posts have shown OT table's schema name. There is a full import only and log excerpt is leaving out "... importing X's objects into ..." part. Like Show 0 Likes(0) Actions 16. Re: Import error: ORA-01438 user10674190 Aug 10, 2012 7:36 PM (in response to user10674190) Thanks everbody for your help. I did table copy from OT, after that I used CSSCAN for identify which line was corrupted, then I deleted this line and export it and I could to import this table in another database. Thanks. Leonardo. Like Show 0 Likes(0) Actions 1 2 Previous Next Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
DBAAutovueBeehiveCRM & SiebelCloudE-Business SuiteIRMJD EdwardsJavaNetBeansOpenOfficeOracle FinancialsOracle RetailPeopleSoftSAPSupply Chain Management Warehouse ManagementServers & StorageHardwareLinuxOracle VDIOracle VMSolarisVirtualBoxVirtualizationOdds & SodsBest PracticesCertificationChannelsIndustry NewsMy Oracle SupportOracle OpenWorldSaaSSecurity Enter your keywords View the results at Google, or enable JavaScript to view them here. You are hereHome IMP-00058:Oracle Error 1438 encountered Thanks to Oracle blog - NIOUG DB for this story Sep 18, 2008 8:00am Database Errors are not really a welcome stuff . Yesterday, I was importing a dump file (from 8.1.7.4) into 10.2.0.3 and hit IMP-00020: long column too large for column buffer size (number). After doing some googling and searching on metalink came to know (not sure though) that it was some bug in 8.1.7.4. And the solution was [...] Read the entire article at its source Feed: Oracle blog - NIOUG DB Original article Featured Top Stories NEW: ROAD for Oracle VM Availability Protection, Disaster Recovery and Operations Automation NEW: Oracle VM Private Cloud Reference Design Oracle Linux Yum Server Setup Guide Oracle VM Manager Installation Guide Oracle VM Server Installation Guide Hard and Soft Partitioning with Oracle VM The Unofficial Oracle Linux 6 Installation and Setup Guide weblogic.nodemanager. common.ConfigException Native version is enabled but node manager native library could not be loaded : NativeVersionEnabled E-T-L Architecture and Business Models Call For Participation is Open for the Xen Project User Summit in New York City MySQL & NoSQL – Best of Both Worlds. Upcoming webinar CRUD Operations in JDeveloper/ADF 11g R1 PS1 Table Component They're playing with my mind! Oracle VM Consulting|Oracle Support|Oracle News|Oracle Enterprise Manager|Oracle Cloud|Oracle LinuxContact|Privacy Statement|Company Info-© Copyright 2015