Oracle Error 22993 Encountered
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Getting error when using Oracle imp command to import dmp file up vote 0 down vote favorite I am importing a dmp file using the following command: imp user/pass file=file.dmp log=logfile.log full=y ignore=y destroy=y I get the following errors: . . importing table "MESSAGE_BOARD" IMP-00058: ORACLE error 22993 encountered ORA-22993: specified input amount is greater than actual source amount IMP-00028: partial import of previous table rolled back: 219638 rows rolled back . . importing table "MESSAGE_BOARD_ARCHIVES" IMP-00058: ORACLE error 22993 encountered ORA-22993: specified input amount is greater than actual source amount IMP-00028: partial import of previous table rolled back: 2477960 rows rolled back I have tried increasing the tablespace size and adding a second datafile to no avail. I'm a total newb at Oracle so any help will be appreciated. Googled this for hours and still can't come up with a solution. Thanks! oracle import share|improve this question asked Oct 5 '12 at 3:23 blizz 1011 migrated from serverfault.com Oct 12 '12 at 21:10 This question came from our site for system and network administrators. add a comment| 1 Answer 1 active oldest votes up vote 1 down vote Basically, your first step should be to try specifying a larger buffer (one large enough to hold your LOB). And, so you're not surprised, this operation can take many, many hours (or even days) depending on the size of the import. And, IIRC, this error can also be thrown if your import version is less than your export version... so check that, if moar buffer doesn't fix this. If that fails, you'll need to provide moar details. ORA-22993: specified input amount is greater than actual source amount *Cause: (1) For LOB write, the amount of data received is different from the amount that was indicated would be sent. (2) For LOB copy and loadfromfile, the end of the
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.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle http://dba.stackexchange.com/questions/25877/getting-error-when-using-oracle-imp-command-to-import-dmp-file VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace https://community.oracle.com/community/developer/search.jspa?q=ORA-22993 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout 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
Submit. Comment is Empty! Name Required Email (User Name) Required Invalid email address. Login | Register What Is The Use Of Oracle Developers In Drools ? What is the use of Oracle developers in drools ? ... http://serverdefects.com/Oracle-Error-12154-While-Importing-Dmp-File~JVRGv8yc38FqhjUmz25daYSG5aAZ7HIdnPN5uOyGiuc=.html View Answer Related Questions Comments Comment can't Submit. Comment is Empty! Name Required Email (User Name) Required Invalid email address. Login | Register Importing Products Via Feeds Csv Import Is Generating Error: "General Error:... I'm http://oraclenix.blogspot.com/2011/09/while-importing-dump-facing-ora-22993.html trying to import products using the import via csv functionality witn feeds and am getting the following Errors: ... SQLSTATE[HY000]: General Error: 1366 Incorrect string value: '\xB7 The ...' for column 'field_description_value' at row 1Error message SQLSTATE[HY000]: oracle error General Error: 1366 Incorrect string value: '\xB7 The ...' for column 'message' at row 1I also have the commerce-feeds module installed. ... View Answer Related Questions Comments Comment can't Submit. Comment is Empty! Name Required Email (User Name) Required Invalid email address. Login | Register Sql Server : Error '3146' When Importing File Using Access As Front End Into... 1.)We are getting below Error when importing file into the SQL server ... oracle error 22993 View Answer Related Questions Comments Comment can't Submit. Comment is Empty! Name Required Email (User Name) Required Invalid email address. Login | Register Sql Server : Importing Xml File Getting An Error [Ssis] I'm trying to import an XML file using XML Source but I'm getting an Error when I try to generate XSD. ... View Answer Related Questions Comments Comment can't Submit. Comment is Empty! Name Required Email (User Name) Required Invalid email address. Login | Register Error While Import Resource File Business Data Connectivity I am trying to use powershell for importing a resource file in Business Data Catalog but I keep getting the following Error ... The root in the given package is 'Model' in namespace'http://schemas.microsoft.com/windows/2007/BusinessDataCatalog/Resources'.Error was encountered at or just before Line: '2' and Position: '2' ... View Answer Related Questions Comments Comment can't Submit. Comment is Empty! Name Required Email (User Name) Required Invalid email address. Login | Register Import A Oracle Dmp File Into A Fresh Install Of Oracle A client sent us a Oracle database we need to test against ... We don't use Oracle or have any Oracle expertise in house. ... I did a fresh install of Oracle 9 (the version the client is running) and the management tools. ... Connected to: Personal Oracle9i Release 9.2.
AL32UTF8. It will solve the problem. ORRecreate the target database with the AL32UTF8 characterset. Posted by Seshagiri Dama at 7:56 AM Labels: ora-22993 No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) About Me Seshagiri Dama I have been working as PL/SQL developer since 2005. I am passionate about oracle performance tuning. I am Oacle 10g DBA certified associate. View my complete profile Blog Archive ► 2012 (19) ► September (1) ► August (4) ► February (14) ▼ 2011 (8) ▼ September (4) How to view the database nls parameters? How to edit the schedule jobs in unix? How to see the schedule jobs in unix? While importing the dump facing ORA-22993 error ► August (4) ► 2009 (6) ► June (3) ► May (3)