Oracle Error 6550 Encountered
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: ora-06550 pls-00201 identifier must be declared oracle line 1, column 7:PL/SQL: Statement ignoredORA-06512: at "SYS.DBMS_SYS_SQL", line 1204ORA-06512: at "SYS.DBMS_SQL", line 323ORA-06512: pls-00302 component must be declared 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 pls-00302: component 'set_no_outlines' must be declared 6510 encounteredORA-06510: PL/SQL: unhandled user-defined exceptionORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 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 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 encountered How to fix the "Could not open virtual machine" vm... How to truncate all tables in a schema which conta... How to change the location of oraInventory. How to import a schema from a dump file and ignore... ► 2007 (2) ► December (1) ► November (1) CONTENTS INSTALLATION ORACLE TECHNIQUES Oracle Identity Management And Internet Directory MISCELLANEOUS My favourite oracle links: Oracle-base Become Apps DBA
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 Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a http://oracle-in-examples.blogspot.com/2008/03/exp-00008-oracle-error-6550-encountered.html minute: Sign up Import error using oracle 10g up vote 1 down vote favorite 1 When I am trying to import a file to a 10g database, Error message (given below) appears. Anybody can help me regarding this ? IMP-00058: ORACLE error 6550 encountered ORA-06550: line 1, column 33: PLS-00302: component 'SET_NO_OUTLINES' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement http://stackoverflow.com/questions/4040291/import-error-using-oracle-10g ignored IMP-00000: Import terminated unsuccessfully sql oracle oracle10g ora-06550 share|improve this question edited May 19 '11 at 5:42 OMG Ponies 199k37361417 asked Oct 28 '10 at 6:16 Umair Awan 167 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Looks like it is a mismatch between the IMP version and database version. If you use the imp that is in the same oracle bin directory as the oracle executable, you may have better luck. That may mean copying the file to the database server. share|improve this answer answered May 19 '11 at 5:58 Gary Myers 28.8k33157 add a comment| up vote 0 down vote I HAVE SIMILAR SITUATION . But in my case we used to have oracle 9i and we used to use bat files to import data(database) due to client requirements we were asked to upgrade to 11gr2 and we did with no problem but when am trying to build a database from other client(we have all databases hosted on same server) i encountered IMP-00058: ORACLE error 6550 encountered ORA-06550: line 1, column 33: PLS-00302: component 'S
FULL=Y option fails with error PLS-00201: identifier ‘SYS.DBMS_DEFER_IMPORT_INTERNAL' must https://gjilevski.com/2010/01/06/export-fully-fails-with-pls-00201-ora-06510-ora-06512/ be declared. From the log file error stack is shown below. Table DEF$_AQCALL will be exported in conventional path. . . exporting table DEF$_AQCALL EXP-00008: ORACLE error 6550 encountered ORA-06550: line 1, column 18: PLS-00201: identifier ‘SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared ORA-06550: line 1, column 7: must be PL/SQL: Statement ignored ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204 ORA-06512: at "SYS.DBMS_SQL", line 323 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126 ORA-06512: at line 1 Table DEF$_AQERROR will be exported in conventional path. . . exporting table DEF$_AQERROR EXP-00008: ORACLE error 6510 must be declared encountered ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126 ORA-06512: at line 1 . . exporting table DEF$_CALLDEST EXP-00008: ORACLE error 6550 encountered ORA-06550: line 1, column 18: PLS-00201: identifier ‘SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204 ORA-06512: at "SYS.DBMS_SQL", line 323 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126 ORA-06512: at line 1 . . exporting table DEF$_DEFAULTDEST EXP-00008: ORACLE error 6510 encountered ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126 ORA-06512: at line 1 . . exporting table DEF$_DESTINATION EXP-00008: ORACLE error 6550 encountered ORA-06550: line 1, column 18: PLS-00201: identifier ‘SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored