Imp-00058 Oracle Error 6550
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security pls-00302: component 'set_no_outlines' must be declared Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back pls-00302 component must be declared CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Ramnath.Awate JoeTorre Andrew.S.Baker bracke Locutus Dennis Stevenson Craig Borysowich Richard DukeGanote mircea_luca iudithm Clinton Jones Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES GeoTrust Juniper Networks HP, Voltage Security and ... Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. IMP-00058: ORACLE error 6550 encountered Debalina Roy asked Dec 12, 2007 | Replies (1) Have taken export from a Oracle 9.2.0.8.0 version server's database. And importing it to a server Oracle 9.2.0.1.0 Now I've given the following import command imp system/system@MyClnt1 file=D:\MyClient\friskdevi41p_exp.dmp log=D:\MyClient\friskdevi41p_imp.log fromuser=FRISKDEVI41p touser=FRISKDEVI41P and I'm getting this 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 Can You Help? Regards, Debalina Roy Join this group Popular White Paper On This Topic ERP Overview Comparison
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: PL/SQL: Statement ignored IMP-00000: Import terminated unsuccessfully Report message to a moderator http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/imp00058-oracle-error-6550-encountered-1764538 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 its permissions (roles/priveleges). Regds Girish Report message to a moderator Re: Problem to import a file [message #134588 http://www.orafaq.com/forum/t/50716/0/ 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 would be fine. Report message to a moderator Re: Problem to import a file [message #145908 is a reply to message #133887] Mon, 07 November 2005 11:18 cynkaranicolas Messages: 1Registered: November 2005 Location: Calgary, Alberta Junior Member I am ha
Topic Database Admin Topics View All Applications Data Mgmt Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Topics Archive Please select a category Topics Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q ORA-06550 error when importing a 10.2 dmp file into a 9.2 database byBrian Peasland An http://searchoracle.techtarget.com/answer/ORA-06550-error-when-importing-a-10-2-dmp-file-into-a-9-2-database Oracle user asks Database Backup and Recovery expert Brian Peasland why they are getting the ORA-06550 error error when importing a 10.2 dmp file into a 9.2 database. Sections Share this item with your network: Related Expert Q&A Problems migrating Oracle 8.1.7.0 to 10.2 – SearchOracle Oracle error 6550 may mean incorrect Oracle export ... – SearchOracle Error messages with import/export – SearchOracle Sponsored News How to Backup All You Want Without Consequences must be –SimpliVity Got Containers? You’ll Need a Way to Monitor Them –Splunk See More Vendor Resources Take Advantage of Oracle's 2 Day DBA Course –Oracle Corporation SAP NetWeaver and Oracle Exadata Database Machine: A Technical Guide for ... –Oracle Corporation UK Ltd I have an Oracle 10.2.0.2 dmp file from another site. I need to import the data into a 9.2.0.6 database on HP-UX11.11. I cannot modify the export file nor do I must be declared have a 10.2 database to import into, but I do have the 10.2 software. Is there any way to import the 10.2 dmp file into a 9.2 database? I attempted to import using the 9.2 software and it didn't recognize the dmp file. I then tried using 10.2 software... Sign in for existing members Continue Reading This Article Enjoy this article as well as all of our content, including E-Guides, news, tips and more. Step 2 of 2: You forgot to provide an Email Address. This email address doesn’t appear to be valid. This email address is already registered. Please login. You have exceeded the maximum character limit. Please provide a Corporate E-mail Address. By submitting my Email address I confirm that I have read and accepted the Terms of Use and Declaration of Consent. By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy. to import into the 9.2 database and received the error: IMP-00058: ORACLE error 6550 encountered ORA-06550: line 1, column 33: PLS-00302: component 'SET_NO_OUTLINES' must be declared OR