Imp 00058 Oracle Error 6550 Encountered Ora 06550
Contents |
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
Pls-00302: Component 'set_no_outlines' Must Be Declared
the company Business Learn more about hiring developers or posting ads with us Stack Overflow pls-00302 component must be declared Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a 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 ignored IMP-00000: Import terminated unsuccessfully sql oracle oracle10g ora-06550 share|improve this question edited May 19 '11 at 5:42 OMG Ponies 199k37356416 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.7k33057 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 'SET_NO_OUTLINES' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored IMP-00000: Import terminated unsuccessfully little bit of googling i found out as i have two oracle homes. i have to check environmental variables , you can check tat To view or change environment variables: Right-click My Computer, and then click Properties. Click the Advanced tab. Click Environment variables. Click one the following options
Mon, 22 August 2005 10:55 Philbzh Messages: 3Registered: August 2005 Junior Member When I try to import a file to a 10g database, I have this error message (see at the bottom). Anybody knows what it is ? I'm using Windows 2000 et a 10g Client. Thanks, Phil. D:\Oracle\product\10.2.0\client_1\BIN>imp Import: Release 10.2.0.1.0 - Production on Mon Aug 22 17:37:05 2005 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: euro@prod Password: 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: http://stackoverflow.com/questions/4040291/import-error-using-oracle-10g PL/SQL: Statement ignored IMP-00000: Import terminated unsuccessfully Report message to a moderator Re: Problem to import a file [message #134503 is a reply to message #133887] Thu, 25 August 2005 05:16 girish.rohini Messages: 744Registered: April 2005 Location: Delhi (India) Senior Member It appears that you have a permissions problem with the user that is running the imp. command. Please check for http://www.orafaq.com/forum/t/50716/0/ its permissions (roles/priveleges). Regds Girish Report message to a moderator Re: Problem to import a file [message #134588 is a reply to message #134503] Thu, 25 August 2005 12:30 Philbzh Messages: 3Registered: August 2005 Junior Member I don't think so because when I'm connect by "sys as sysdba", I have the same problem. Have you got another idea ? Thanks, B.R. Report message to a moderator Re: Problem to import a file [message #135830 is a reply to message #133887] Fri, 02 September 2005 14:42 felipedangelo Messages: 1Registered: September 2005 Junior Member I had problem the same. How he obtained to decide? please it helps me! Thanks. Report message to a moderator Re: Problem to import a file [message #136461 is a reply to message #135830] Thu, 08 September 2005 02:38 Wieldop Messages: 1Registered: September 2005 Junior Member I had the same problem. I was using the imp.exe from the 10.2.0 release (like you did) while the database in which I wanted to import the dump was in fact 10.1.0. So, stick to the imp.exe of 10.1.0 and everthing woul
while importing into oracle 10.1 using 10.2 Client If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to http://www.dbasupport.com/forums/showthread.php?55695-Error-while-importing-into-oracle-10-1-using-10-2-Client register before you can post: click the register link above to proceed. To https://community.oracle.com/thread/951688?db=5 start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: Error while importing into oracle 10.1 using 10.2 Client Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch must be to Threaded Mode 07-11-2007,08:28 AM #1 issacgeorge View Profile View Forum Posts Junior Member Join Date Sep 2005 Posts 46 Error while importing into oracle 10.1 using 10.2 Client Hai every body, I have a client db dump taken from oracle 10.2 DB using a 10.2 client. But what I have is 10.1 DB. While importing I got errors. Hence i installed a 10.2 client must be declared and tried importing into 10.1 using the 10.2 client. But then i got the following error. 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 ignored IMP-00000: Import terminated unsuccessfully Since its a client DB, i cannot ask for exporting again. Is there any way to solve this issue. I mean, i need to import a 10.2 dump into a 10.1 DB either using 10.1 client or 10.2 client. regards Issac Reply With Quote 07-11-2007,08:32 AM #2 Bore View Profile View Forum Posts Visit Homepage Advisor Join Date Nov 2006 Location Sofia Posts 630 It is not supported to import a dump from later version into earlier, so that is not a surprise. Maybe you can connect to 10.2 with 10.1 exp and try exporting with 10.1 client Regards Reply With Quote 07-11-2007,08:57 AM #3 PAVB View Profile View Forum Posts Senior Advisor Join Date Mar 2007 Location Ft. Lauderdale, FL Posts 3,555 Issac, You might want to check Metalink Note:132904.1 -Compatibility Matrix for Export & Import Between Different Oracle Versions Pablo (Paul) Berzukov Author of Understanding Database Administration ava
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 enter a title. You can not post a blank message. Please type your message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL This discussion is archived 3 Replies Latest reply on Aug 27, 2009 5:36 AM by Toon Koppelaars Import error ( while exporting data from 10g to 9i) 641320 Aug 27, 2009 5:12 AM Hai friends Recently we migrated from 9i to 10g. circumstances made us take back of 10g (some tables) and import into 9i.we are using HP UNIX server i cannot able to iimport.. as i got error as below 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 ignored IMP-00000: Import terminated unsuccessfully i guess due to Import: Release 10.2.0.2.0 - Production on Thu Aug 27 07:11:07 2009 how can i OVERCOME this issue? kindly help S 337Views Tags: none (add) This content has been marked as final. Show 3 replies 1. Re: Import error ( while exporting data from 10g to 9i) Toon Koppelaars Aug 27, 2009 5:15 AM (in response to 641320) If you're moving data from 10G to 9i, using EXP/IMP, I would try using the 9i EXP to create the dumpfile with data from the 10G database, and then using the 9i IMP to import that dumpfile into the 9i database. Sounds like you have been using the 10G EXP and IMP in both cases. Like Show 0 Likes(0) Actions 2. Re: Import error ( while exporting data from 10g to 9i) 641320 Aug 27, 2009 5:20 AM (in response to Toon Koppelaars) hai thanks for your reply, can you kindly tell me how can i use 9i exp in 10g database? where can i found it? how can i change it from 10g exp to 9i exp? waiting S Edited by: AswinGousalya on Aug 27, 2009 10:50 AM Like Show 0 Likes(0) Actions 3. Re: Import error ( while exporting data from 10g to 9i) Toon Koppelaars Aug 27, 2009 5:36 AM (in response to 641320) Just run the EXP utility from the 9i ORACLE_HOME environment that you have. And connect (using use