Oracle Imp Error 6550
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 pls-00302: component 'set_no_outlines' must be declared Overflow the company Business Learn more about hiring developers or posting ads with us pls-00302 component must be declared Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community ora-6550 of 6.2 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 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 '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. Cl
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 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 http://stackoverflow.com/questions/4040291/import-error-using-oracle-10g 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 –SimpliVity Got Containers? You’ll Need a Way to Monitor Them –Splunk See More Vendor Resources Take Advantage of Oracle's http://searchoracle.techtarget.com/answer/ORA-06550-error-when-importing-a-10-2-dmp-file-into-a-9-2-database 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 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 pro
am UTC Category: Database � Version: 9.2 Whilst you are here, check out some content from the AskTom team: 12.2 Helps You Manage Persistent Code Base w/New Deprecate Pragma Latest Followup You Asked Hi Sir, I recently did https://asktom.oracle.com/pls/asktom/f%3Fp%3D100:11:0::::P11_QUESTION_ID:11511550949535 an exp of one of our production schema version 817. I want to imp this http://www.dbasupport.com/forums/showthread.php?12488-Errors-while-trying-to-import-a-Full-Database-export on my local laptop where Database server is installed version 9.2. I created the same user with LMT and auto extend of size 500 MB.The production DB schema was not LMT but DMT. I kept getting this error during imp like IMP-00003: ORACLE error 1659 encountered ORA-01659: unable to allocate MINEXTENTS beyond 4 in tablespace USER_DATA IMP-00017: following statement must be failed with ORACLE error 1658: "ALTER TABLE "XYZ" ADD PRIMARY KEY ("XYZ_PK") USING INDEX PCTFREE 10 I" "NITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4194304) TABLESPACE "USER_DATA" ENAB" "LE". or some errors like IMP-00003: ORACLE error 1658 encountered ORA-01658: unable to create INITIAL extent for segment in tablespace USER_DATA IMP-00017: following statement failed with ORACLE error 1659: "CREATE TABLE "DEPT" ("DEPT_NUM" NUMBER(22, 0) NOT NULL ENABLE, "USERI" "D" NUMBER(22, 0), "LASTMOD" DATE, "COL_NUM1" NUMBER(22, 0) must be declared NOT NULL ENABLE" ", "COL_NUM2" NUMBER(22, 0) NOT NULL ENABLE, "COL_NUM3" NUMBER(22, 0)) PCTF" "REE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 4194304) " "TABLESPACE "USER_DATA"" IMP-00003: ORACLE error 1659 encountered ORA-01659: unable to allocate MINEXTENTS beyond 3 in tablespace USER_DATA So I had to increase the datafile size associated with the Tablespace. I kept getting this error until I created 10 datafiles of 1 GB each for the same tablespace. All the objects are in one tablespace user_data. Only then the Import was successful. Question 1)If i used LMT with auto extend why did it run out of space and not extend itself automatically.As it is LMT should it not ignore the initial extents etc etc clause.( I did not use uniform allocation) 2)I know there is not much data in the schema but the way the create tables have done it takes some many extents resulting in 10 Gb tablespace.only 4 tables have about 30000 rows. Am i correct inthis assumption. How to reduce this extra tablespace consumption of 10 Gb total datafiles. 3)wrt point 2 I am sure schema will fit in datafile of just 300 MB how to do this.When I did the exp i used direct path and compress=n Thank you Sir. and we said... 1) lmts do not IGNORE initial, next,
while trying to import a Full Database export If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: Errors while trying to import a Full Database export Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 06-26-2001,10:40 AM #1 anuragmin View Profile View Forum Posts Senior Member Join Date Sep 2000 Posts 362 Hi, I have a full database export from an Oracle 8.0.5 database which i am trying to import into an Oracle 8.1.7 database. I have created the database and all the tablespaces in Oracle 8i. (The tablespaces and datafiles in 8i are not in the same location as the ones in Oracle 8.0.5). Now when i am trying to do a full import using imp system/manager@news8i file=expdat.dmp full=y ignore=y I get the following errors IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'SVEN' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "MTARNEY" QUOTA UNLIMITED ON "TEMPORARY" QUOTA UNLIMITED ON "NEW" "S_DATA"" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'MTARNEY' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "LUCY" QUOTA UNLIMITED ON "NEWS_INDEX" QUOTA UNLIMITED ON "NEWS_" "DATA"" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'LUCY' does not exist IMP-00017: following statement failed with ORACLE error 2221: "CREATE PUBLIC ROLLBACK SEGMENT RB0 STORAGE (INITIAL 57344 NEXT 81920 MINEXT" "ENTS 2 MAXEXTENTS 2147483645) TABLESPACE "RBS"" IMP-00003: ORACLE error 2221 encountered ORA-02221: invalid MAXEXTENTS storage option value IMP-00017: following statement failed with ORACLE error 2221: "CREATE PUBLIC ROLLBACK SEGMENT RB1 STORAGE (INITIAL 57344 NEXT 81920 MINEXT" "ENTS