Oracle Error 6550 Encountered Export
Topic Backup and recovery Database Admin View All Cloud infrastructure Availability Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Applications View All Enterprise and business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q Oracle error 6550 may mean incorrect Oracle export version byBrian Peasland Oracle expert Brian Peasland explains why you might get an Oracle error 6550 when using the wrong Oracle export version in this tip. Sections Share this item with your network: Related Expert Q&A Errors exporting an Oracle database – SearchOracle Error during export of 10g database – SearchOracle Problems migr
or system), and got the following errors:.... about to export SYSTEM's tables via Conventional Path .... . exporting table DEF$_AQCALLEXP-00008: ORACLE error 6550 encounteredORA-06550: line 1, column 18:PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredORA-06512: at "SYS.DBMS_SYS_SQL", line 1204ORA-06512: at "SYS.DBMS_SQL", line 323ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126ORA-06512: at line 1. . exporting table DEF$_AQERROR.... . exporting table DEF$_ERROREXP-00008: ORACLE error 6510 encounteredORA-06510: PL/SQL: unhandled user-defined exceptionORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line http://searchoracle.techtarget.com/answer/Oracle-error-6550-may-mean-incorrect-Oracle-export-version 126ORA-06512: at line 1. . exporting table DEF$_LOB 0 rows exported...I have found that we need to grant some sys procedures to this user for getting rid of these errors.So I logged in as sys and executed the following commands:GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO ;GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO ;And it really helped me to fix it.Thanks,Sergey. Posted by Sergey http://oracle-in-examples.blogspot.com/2008/03/exp-00008-oracle-error-6550-encountered.html at 1:27 PM 6 comments: siva said... Wow - works like a miracle.Really good solution.Thanks. February 5, 2009 at 9:08 PM Anonymous said... WOW .... that really workedi was facing the same problem for couple of weeks and even Oracle support was not giving a solution.but this trick really works .... thanks for sharing this June 24, 2010 at 11:41 PM Anonymous said... Thanks sergio, U.B.D.Man November 11, 2010 at 2:24 PM Chilli Honey said... Hi Guys,Unfartunately i am using sys user to export the database eventhough i am getting the same error.Please advise what could be the reason.Regards,Salai December 30, 2010 at 1:49 PM Toksy said... Thanks a lot. This works and it makes sense March 17, 2011 at 11:49 AM Anonymous said... It worked like a charm. Thanks. April 15, 2015 at 8:51 AM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) About Me Sergey View my complete profile Blog Archive ▼ 2008 (21) ► July (10) ► May (2) ► April (4) ▼ March (5) EXP-00008: ORACLE error 6550
08, 2010 - 10:36 am UTC Category: Database � Version: version 7.3.2.3 Whilst you are here, check out some content from the AskTom team: Existence checks Latest Followup You Asked https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:704225010478 Dear Tom, recently (last week actually!) I started exporting some of my Bases via MS-DOS direct to my PC using either 'exp' or 'exp80' depending on the Base. With one of them (Bases that is!)I keep on getting the following error 'exporting table TDATOSGENERALES EXP-00014: error on row 583691 of table TDATOSGENERALES EXP-00008: ORACLE error 1013 encountered ORA-01013: user requested cancel oracle error of current operation exporting table TDATOSGENERALESANT 778522 rows exported etc etc. This error is random i.e occuring on different tables every time I attempt to export but always with the same Schema/User. There is absolutely no activity on that Schema when it happens so can you help me find a solution. My first thought was that it was something to do with oracle error 6550 the size of the table as it seems to occur only on tables with large number of rows but what is driving me up the wall is the randomness of it! I did see the archive where you speak about this viz. a viz SQLPlus and Unix terminals etc. Do you know if the equivilant of 'stty isig' exists in the MS-DOS world. My PC is running W95 and the Base I am trying to export is Oracle 7.3.2.3 I would like to take this opportunity to thank you for the most usefull response you gave me recently viz. a viz ORA-1555 and Export. The support note 40689.1 was most comprehensive and clear. While I am on the subject can you tell me where I can find an archive of Support notes on the OTN, or if such a thing exists. If 40689.1 was anything to go by I feel I might progress faster with my Oracle education with them rather than the manuals! Regards, Michael and we said... Well, yet another support note to the rescue maybe..... Article-ID: