Oracle Error 942 Encountered Exp
before applying anything on production.You can reach to me at neeraj.vishen@gmail.com . Monday, October 10, 2011 EXP-00008: ORACLE error 942 encountered , ORA-00942 Once while visiting OTN , i found a user is facing the below error while performing exporting C:\> exp hr/hr tables=batch_job Export: Release 10.2.0.3.0 - Production on Mon Oct 10 14:34:35 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set server uses UTF8 character set (possible charset conversion) About to export specified tables via Conventional Path ... . . exporting table BATCH_JOB EXP-00008 : ORACLE error 942 encountered ORA-00942: table or view does not exist Export terminated successfully with warnings. While connecting connecting with "HR" user C:\Documents and Settings\admin>sqlplus hr/hr SQL*Plus: Release 10.2.0.3.0 - Production on Mon Oct 10 14:34:58 2011 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production SQL> select count(*) from batch_job; COUNT(*) ---------- 37311 Solution : There may various possible solution .The following are 1.) One of the possible solution is that the view "SYS.EXU9TYP" which is used by EXP is missing. So to solve this issue follow the below steps : I.) Ensure no application user connect to database. II.) Run the following script SQL>@?/rdbms/admin/catexp.sql SQL>@?/rdbms/admin/catpatch.sql III.) Re-try EXP. 2.) Secondly,it also seems that the problem is clearly with the version of exp i.e; Exporting with version : 10.2.0.3 Connecting to database : 10.2.0.1 3.) Export proper home and perform export, even with exp still we can solve our problem but always recommended to use
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed http://neeraj-dba.blogspot.com/2011/10/exp-00008-oracle-error-942-encountered.html Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Oracle: Oracle release - 9i and earlier Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesOracle: Oracle release - 9i and earlier Forum EXP error 942 Table or view does not exit on server? thread759-715396 Forum Search FAQs Links MVPs EXP error 942 Table or view does not exit on server? EXP error http://www.tek-tips.com/viewthread.cfm?qid=715396 942 Table or view does not exit on server? lydiattc (Programmer) (OP) 25 Nov 03 14:13 Hi,I'm doing an export on the server, Oracle 9.2.0.1.0. However, I received an error message like this: Table or view does not exist, ORA-error-942. Any idea what went wrong?Thanks,Lydia RE: EXP error 942 Table or view does not exit on server? avjoshi (IS/IT--Management) 25 Nov 03 14:25 Are you using export, import utilities from the same version? Anand. RE: EXP error 942 Table or view does not exit on server? dbtoo2001 (MIS) 25 Nov 03 14:46 The following information is from the metalink website:Limitations. ------------The following limitations apply to the EXPORT and IMPORT utilities (seedetails in the matrix below):1. Oracle export dump files can only be read by the Oracle IMPORT utility because these dump files are stored in a special Oracle-binary format. 2. Every export dump file is importable into all future major, patch, andmaintenance releases of Oracle. 3. The export dump files cannot be read by IMPORT utilities of previous maintenance releases and versions.So, a version 9 export dump file cannot be imported by a version 8i IMPORT utility (possible errors:IMP-10 and IMP-21), and a version 8 export
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 https://community.oracle.com/message/4007502 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 oracle error 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 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 oracle error 942 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 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: