Oracle Error 942 Encountered Export
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 expdp/impdp instead of exp/imp in oracle 10g and higher version . 4.) Finally to find out exactly what's wrong, check for a trace file in CORE_DUMP_DEST directory. Enjoy :-) Posted by NEERAJ VISHEN at Monday, October 10, 2011 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search This Blog Loading... Translate My Page About Me NEERAJ VISHEN Gurgoan, Ncr/Delhi, India I have started this blog to share my knowledge and experience
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 12 Replies Latest reply on May 27, http://neeraj-dba.blogspot.com/2011/10/exp-00008-oracle-error-942-encountered.html 2016 4:37 AM by Ahmed Haroon Oracle DB 11g - Problem while exporting table(s) with Virtual Columns Ahmed Haroon May 25, 2016 10:09 AM hi all,Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsWe have virtual columns on some tables, when we https://community.oracle.com/thread/3933645 importing these tables ( .DMP file ) oracle showing error like this ( exported using TOAD Export Utility Wizard ) and importing using command line oracle's imp utility. i checked there is no problem with Character Set on both machines are same.is it the limitation of virtual column? oracle allow to Partition on these virtual columns then ... or my be i am doing something wrong or missing ?output of imp utility:IMP-00017: following statement failed with ORACLE error 984:" ALTER TABLE "PA_FATCA_INDIV" MODIFY ("US_RES" DEFAULT CASE WHEN ""("US_RESIDENT"='Y' OR "US_CITIZEN"='Y' OR "US_PERM_RES_CARD"='Y' OR "US_TAX""_PAYER"='Y') THEN 'Y' ELSE 'N' END )"will somebody help for this problem? i will be much grateful.with best regards. 963Views Tags: none (add) This content has been marked as final. Show 12 replies 1. Re: Oracle DB 11g - Problem while exporting table(s) with Virtual Columns Selvakumar.Nagulan May 25, 2016 10:49 AM (in response to Ahmed Haroon) Hi,What is the underlying Oracle er
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be http://www.tek-tips.com/viewthread.cfm?qid=715396 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 oracle error What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed 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 oracle error 942 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 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-bin