Oracle Error 942 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 7 Replies Latest reply on Jan 8, 2010 6:00 AM by 668860 Importing indexes causing - ORA-00942 668860 Jan 5, 2010 11:19 AM http://dbaforums.org/oracle/index.php?showtopic=21902 Hello, we have an automated refresh using export/import utilitiy on our Oracle 8.1.7.4 database. during import we are getting ORA-00942 errors while creating indexes for only few tables. one weird thing is import process is trying to create indexes for few tables before table creation itself. Import creates indexes after importing table, not sure what is happening in this case: Below https://community.oracle.com/message/4007502 is the import log. any idea whats causing this... ============================================================= . . importing table "PS_PSI_PRFTSHR_EMP" 92 rows imported . . importing table "PS_PSI_PRFTSHR_SEC" 0 rows imported . . importing table "PS_PSI_PROFIT_SHAR" 21374 rows imported . . importing table "PS_PSI_PRSNNL" 13793 rows imported IMP-00017: following statement failed with ORACLE error 942: "CREATE UNIQUE INDEX "PS_PSI_REP_TST" ON "PS_PSI_REP_TST" ("EMPLID" , "EMPL_" "RCD" , "EFFDT" , "EFFSEQ" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INI" "TIAL 532480 NEXT 106496 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FR" "EELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "PSINDEX" LOGGI" "NG" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "CREATE INDEX "PS0PSI_REP_TST" ON "PS_PSI_REP_TST" ("DEPTID" , "EMPLID" , "E" "MPL_RCD" , "EFFDT" , "EFFSEQ" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE" "(INITIAL 655360 NEXT 106496 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE " "0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "PSINDEX" L" "OGGING" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "CREATE I
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help https://www.experts-exchange.com/questions/20896651/import-error-imp-00003-an-oracle-error-942-encountered.html Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > import error: imp-00003 an oracle error 942 encountered. Want to Advertise Here? Solved import error: imp-00003 an oracle error oracle error 942 encountered. Posted on 2004-02-24 Oracle Database 2 Verified Solutions 6 Comments 4,204 Views Last Modified: 2012-11-16 Hi experts, I am trying to import tables into a newly created instance. right after I type : imp login/password i got this error: imp-00003 an Oracle error 942 encountered ORA-0942 a table or view does not exist imp-00023 imp view oracle error 942 does not installed, please notify your DBA What should I do to fix this problem? thanks. 0 Question by:panpanW Facebook Twitter LinkedIn Google LVL 23 Best Solution byseazodiac ok, in that case, you have NOT run the catalog.sql and catproc.sql already.(they are in the same folder as catexp.sql) again, log in as sysdba SQL>@catalog.sql SQL>@catproc.sql Go to Solution 6 Comments LVL 23 Overall: Level 23 Oracle Database 23 Message Assisted Solution by:seazodiac2004-02-24 log in as sysdba, run catexp.sql under %ORACLE_HOME%/rdbms/admin folder 0 LVL 23 Overall: Level 23 Oracle Database 23 Message Expert Comment by:seazodiac2004-02-24 after that, try your imp command again. the reason is that you have not created IMP/EXP dictionary views 0 Message Author Comment by:panpanW2004-02-24 thansk. But, I am getting "package STANDARD not accessible" error. why? 0 LVL 23 Overall: Level 23 Oracle Database 23 Message Accepted Solution by:seazodiac2004-02-24 ok, in that case, you have NOT run the catalog.sql and catproc.sql already.(they are in the same folder as catexp.sql) again, log in as sysdba SQL>@catalog.sql SQ