Oracle Error 1461 Encountered
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a complete UI toolbox for web, mobile and desktop development OpenEdge Build, protect and deploy apps across any platform and mobile device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build mobile apps for iOS, Android and Windows Phone Nativescript Use Angular, TypeScript or JavaScript to http://dbaforums.org/oracle/index.php?showtopic=18867 build truly native mobile apps Rollbase Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud Data Connectivity DataDirect Connectors http://knowledgebase.progress.com/articles/Article/P119314 Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management Download Center Services Training Consulting Services Managed Database Offering Learning Documentation Webinars How-To Videos Whitepapers Community Blogs Success Stories Partners Company Login Progress Support Rollbase
Error If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register http://www.dbasupport.com/forums/showthread.php?61848-Import-Error link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: Import Error Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-17-2011,12:17 PM #1 Tuma View Profile View Forum Posts Member Join Date Apr oracle error 2007 Location USA Posts 110 Import Error All, I run an import and get IMP-00058: ORACLE error 1461 encountered ORA-01461: can bind a LONG value only for insert into a LONG column IMP-00028: partial import of previous table rolled back: 40443 rows rolled back The export client is oracle 8i and import client is 11g. I know I could set NLS_LANG but I tried and it oracle error 1461 doesn't work yet. ===the 8i exporting database-- SQL> select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET'; PARAMETER VALUE ---------------------- -------- ----------------------------NLS_CHARACTERSET US7ASCII ========the 11g importing database=== PARAMETER VALUE --------------------- --------------------- NLS_CHARACTERSET AL32UTF8 here is my NLS_LANG setting before running the import which failed.. set NLS_LANG=AMERICAN_AMERICA.US7ASCII export NLS_LANG thanks... Looking for the greatest evil in the world? Look in the mirror. Reply With Quote 03-17-2011,01:27 PM #2 stecal View Profile View Forum Posts Super Moderator Join Date May 2002 Posts 2,645 How did you make the connection between that error result (inserting a LONG into a column that doesn't support LONG) and the character sets? Reply With Quote 03-17-2011,02:05 PM #3 Tuma View Profile View Forum Posts Member Join Date Apr 2007 Location USA Posts 110 Originally Posted by stecal How did you make the connection between that error result (inserting a LONG into a column that doesn't support LONG) and the character sets? because there is no LONG field on the table, the table is exported and imported as is...and some googling suggests is a client character set issue. Looking for the greatest evil in the world? Look in the mirror. Reply With Quote 03-18-2011,02:00 PM #4