Oracle Error 942 Encountered Import
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 Export/Import/SQL Loader & External Tables All PlacesDatabaseOracle Database + OptionsExport/Import/SQL Loader & External Tables This discussion is archived 10 Replies Latest reply on Sep 5, 2012 11:46 PM by Srini Chavali-Oracle How to fix this error: IMP-00003: ORACLE error 1435 encountered 958907 Aug 30, 2012 2:33 AM Hello, I am new to oracle database. I http://dbaforums.org/oracle/index.php?showtopic=21902 am trying import a data dump file *.dmp into my test database. I am using Oracle Database 11g. I have created "datatest" to be the user and I granted all possible rights that was there. :) but still getting this error message. Does Oracle has a GUI tool somewhere I can try or how I can fix this issue? PLEASE HELP. Below are the actions taken: ========================================================================= C:\app\Administrator\admin\ORCLENT1\dpdump>imp https://community.oracle.com/thread/2435501 Import: Release 11.2.0.1.0 - Production on Wed Aug 29 22:32:39 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: datatest Password: Connected to: Personal Oracle Database 11g Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Import data only (yes/no): no > no Import file: EXPDAT.DMP > expdat.dmp Enter insert buffer size (minimum is 8192) 30720> 8299 Export file created by EXPORT:V11.02.00 via conventional path Warning: the objects were exported by SYSTEM, not by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) List contents of import file only (yes/no): no > no Ignore create error due to object existence (yes/no): no > no Import grants (yes/no): yes > yes Import table data (yes/no): yes > yes Import entire export file (yes/no): no > yes . importing SYSTEM's objects into DATATEST . importing DW_OWNER's objects into DW_OWNER IMP-00003: ORACLE error 1435 encountered ORA-01435: user does not exist Import terminated successfully with warnings. ============================================================= I have the same question Show 0 Likes(0) 3017Views Tags: none (add) 11gContent tagged with 11g, databaseContent tagged with database, errorContent tagged with error, im
Installation and Configuration: Server; Windows; Unix; Linux; ORA-00942; IMP-00017; rpm Technote (troubleshooting) Problem(Abstract) This technote explains why http://www.ibm.com/support/docview.wss?uid=swg21330529 in some instances, when restoring an Oracle database or moving it from one version of Oracle to another, there are errors that can be encountered during the import http://www.dbasupport.com/forums/showthread.php?48245-Error-in-importing-Index-orgainzed-table process when using IBM Rational Portfolio Manager. Symptom IMP-00017: following statement failed with ORACLE error 942: ... An example of the full error is shown below: IMP-00017: following oracle error statement failed with ORACLE error 942: "CREATE INDEX "HSRSC_RID_RDT_XX" ON "HISTORY_RESOURCES" ("RESOURCE_ID" , "RE" "C_DATETIME" DESC ) PCTFREE 30 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 6553" "6 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "PMO_IDX_64" "K" LOGGING" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist Cause Unknown Resolving the problem While these oracle error 942 instructions and examples are focused on Microsoft Windows, these instructions are valid for Unix and Linux. Please keep in mind the difference between these environments. Create a SQL Script file to create the Import DB Fix 1. Based on the error messages received, build the SQL script file in the following manner: a. Open a text file b. Type in the following command, without the delimiters and
: spool impErrorFix.log
c. Copy the statement from the error message Example: "CREATE INDEX "HSRSC_RID_RDT_XX" ON "HISTORY_RESOURCES" ("RESOURCE_ID" , "RE" "C_DATETIME" DESC ) PCTFREE 30 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 6553" "6 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "PMO_IDX_64" "K" LOGGING" d. Remove all soft returns Example: "CREATE INDEX "HSRSC_RID_RDT_XX" ON … "K" LOGGING" Note: do not remove any text, the example was truncated to show the beginning and end of the line. e. Remove all quotes from the statement Example: CREATE INDEX HSRSC_RID_RDT_XX ON HISTORY_RESOURCES (RESOURCE_ID, REC_DATETIME DESC ) PCTFREE 30 INITRANS 2 MAXTR
in importing Index orgainzed table 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 1 of 1 Thread: Error in importing Index orgainzed table Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-22-2005,02:05 PM #1 vjikki View Profile View Forum Posts Junior Member Join Date Jul 2005 Posts 2 Error in importing Index orgainzed table Hi, I am trying to import an index organized table from one schema to another in a different machine, I get the following error : ----------------------------------------------------------- Export file created by EXPORT:V10.01.00 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses WE8ISO8859P1 character set (possible charset conversion) . importing PROADMIN2_PRD's objects into PROADMIN2_PRD . . importing table "PRO_RELATIONS_CHILD" IMP-00058: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "CREATE INDEX "IDX_CHILD_RECORD_ID" ON "PRO_RELATIONS_CHILD" ("RECORD_ID" ) " " PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4194304 FREELISTS 1 FRE" "ELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TBS_IDX_QUEUE_DATA" NOLOGGI" "NG" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 20000: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IDX_CHILD_RECORD_ID"',NULL,NULL,NU" "LL,5728901,48154,85602,1,66,5728901,2,2); END;" IMP-00003: ORACLE error 20000 encountered ORA-20000: INDEX "PROADMIN2_PRD"."IDX_CHILD_RECORD_ID" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 1688 ORA-06512: at "SYS.DBMS_STATS", line 4781 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 942: ------------------------------------------------------------ I run Oracle 10.1.0.3. on both machines. I don't get this error fo