Imp-00058 Oracle Error 3114 Encountered
while importing ? 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 imp-00003 oracle error 3113 encountered can post: click the register link above to proceed. To start viewing imp 00058 oracle error 3113 encountered messages, select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: error while importing ? Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-16-2008,01:40 AM #1 gopu_g View Profile View Forum Posts Senior Member Join Date Aug 2007 Location Cyberjaya,kuala lumpur Posts 340 error while importing ? i am importing remotely to the database. The size of the dump is 9GB.After a long time.. the import is terminated with the below error.....please suggest. IMP-00058: ORACLE error 12571 encountered ORA-12571: TNSacket writer failure IMP-00058: ORACLE error 3114 encountered ORA-03114: not connected to ORACLE IMP-00000: Import terminated unsuccessfully Thanks/Gopu Reply With Quote 12-16-2008,04:01 AM #2 PAVB View Profile View Forum Posts Senior Advisor Join Date Mar 2007 Location Ft. Lauderdale, FL Posts 3,555 What are errors ORA-12571 and ORA-03114 suggesting to you? Pablo (Paul) Berzukov Author of Understanding Database Administration available at amazon and other bookstores. Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice. Reply With Quote 12-16-2008,04:36 AM #3 gopu_g View Profile View Forum Posts Senior Member Join Date Aug 2007 Location Cyberjaya,kuala lumpur Posts 340 Originally Posted by PAVB What are errors ORA-12571 and ORA-03114 suggesting to you? but the database is up and running fine ?? Thanks/Gopu Reply With Quote 12-16-2008,04:40 AM #4 PAVB View Profile View Forum Posts Senior Advisor Join Date Mar 2007 Location Ft. Lauderdale, FL Posts 3,555 Originally Posted by gopu_g but the database is up and running fin
24 March 2008 00:22 daniesh.shaikh@gmail.com Messages: 62Registered: February 2008 Location: india Member Hi Experts, i am getting while taking imp. i am unable to find the solution could you please help me out. i have pasted error and the command which i used for taking imp. imp system file=zsuserzspune.dmp log=zsuserzspune_imp.log fromuser=ZSUSER touser=ZSUSER commit=y buffer=10000000 importing table "SSD_ONHAND_FINANCE_REP" 20843 rows imported . . importing table "SSD_ONHAND_FIN_ELSTMP" 23088 rows imported . . importing table "SSD_ORG_CYCLE_ENTITY_DETAILS" 635 rows imported . http://www.dbasupport.com/forums/showthread.php?59119-error-while-importing . importing table "SSD_PENDING_TMP" 60 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "SSD_PENDING_TMP" TO "APPS"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'APPS' does not exist . . importing table "SSD_SF_ONHAND_WIPMOVE" 28738554 rows imported IMP-00017: following statement failed with ORACLE error 603: "CREATE UNIQUE INDEX "SFOW_PK" ON http://www.orafaq.com/forum/t/99422/ "SSD_SF_ONHAND_WIPMOVE" ("SESSIONCODE" , "" "INVENTORY_ITEM_ID" , "SUBINVENTORY_CODE" , "LOCATOR_ID" ) PCTFREE 10 INITR" "ANS 2 MAXTRANS 255 STORAGE(INITIAL 1323089920 NEXT 27615232 MINEXTENTS 1 MA" "XEXTENTS 2147483645 PCTINCREASE 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL" " DEFAULT) TABLESPACE "USERS" LOGGING" IMP-00003: ORACLE error 603 encountered ORA-00603: ORACLE server session terminated by fatal error IMP-00017: following statement failed with ORACLE error 3114: "ALTER SESSION SET SKIP_UNUSABLE_INDEXES=FALSE" IMP-00003: ORACLE error 3114 encountered ORA-03114: not connected to ORACLE IMP-00000: Import terminated unsuccessfully me: ok wait let me check amjadshk: AND IN ALERT LOG [oracle@cloneapps bdump]$ vi alert_clone.log Current log# 3 seq# 1285 mem# 0: /apps/oracle/ias/infra/oradata/clone/redo03.log and in alert log i can see this ORA-1653: unable to extend table ZSUSER.XXX_ZS_MS_TRAN_PEB by 128 in tablespace USERS ORA-1653: unable to extend table ZSUSER.XXX_ZS_MS_TRAN_PEB by 128 in tablespace USERS ORA-1652: unable to extend temp segment by 128 in tablespace USERS Report message to a moderator Re: import in 10g [message #308306 is a reply to message #308302] Mon, 24
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 http://www.dbforums.com/showthread.php?988930-Import to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 15 of 16 Thread: Import Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-17-04,08:35 #1 dr_suresh20 View Profile View Forum Posts Registered User Join Date Sep 2003 Posts 218 Unanswered: Import I am using oracle error Oracle 9.x.x on Win2k. I have a full export oracle db dump (80 GB), & I try to bring in the full import into a existing db. There is only one schema owner and it is for this user, I am trying to import data. I'm getting a lot of ORA-2291 parent key not found errors. I tried using rows=y constraints=n indexes=n in a parameter file but i still get oracle error 3113 ORA-2291 errors on the screen. Besides, it nearly takes two days to complete a 80 GB db dump import. What's the best way of successfully doing this? Many thanks. Reply With Quote 03-17-04,08:59 #2 SkyWriter View Profile View Forum Posts Registered User Join Date Jan 2004 Posts 370 You must have constraints on the existing tables. Reply With Quote 03-17-04,09:13 #3 osy45 View Profile View Forum Posts Registered User Join Date Nov 2002 Posts 833 imp is doning loading tables in alphabetical order, but to me it sounds you are going to imp into a schema which is not empty ... assign a redo/undo segment as large as you can at least use a buffer of at least 16000000 and separate loading data from index use commit=n Reply With Quote 03-17-04,09:46 #4 dr_suresh20 View Profile View Forum Posts Registered User Join Date Sep 2003 Posts 218 Thanks... to you both for quick response. Firstly, If constraints are enabled then "constraints=n" is supposed to take care of it right? Secondly, if import is happening alphabetically - then do I have any control on the list of tables to be imported? Reply With Quote 03-17-04,09:53 #5 osy45 View Profile View Forum Posts Registered User Join Date Nov 2002 Posts 833 Ori