Exp-00008 Oracle Error 942 Encountered
Contents |
before applying anything on production.You can reach to me at neeraj.vishen@gmail.com . Monday, October 10, 2011 EXP-00008: exp 00056 oracle error 31600 encountered ORACLE error 942 encountered , ORA-00942 Once while visiting OTN , i
Exp 00008 Oracle Error 21779 Encountered
found a user is facing the below error while performing exporting C:\> exp hr/hr tables=batch_job Export: Release oracle error 942 encountered import 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 NEERA
? Ask a question, help others, and get answers from the community Discussions Start a thread and discuss today's topics with top experts Blogs Read the latest tech blogs written by experienced community members Oracle 9i export unsuccessful since patch update. aglking pts. Tags: Thanks! We'll email youwhen relevant content isadded and updated. Following Follow Oracle Hi, i'm quite new to oracle, i've got an oracle 9i database been running 1 year, which runs an export every night. Everything has been working fine on 9.2.0.1.0. I updated straight to 9.2.0.7.0. Everything else looks ok. Users, still happy. Now export fails with: Connected to: Oracle9i Release 9.2.0.7.0 - Production JServer http://neeraj-dba.blogspot.com/2011/10/exp-00008-oracle-error-942-encountered.html Release 9.2.0.7.0 - Production Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles . exporting resource costs . exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context namespaces . exporting foreign function library names . exporting PUBLIC http://itknowledgeexchange.techtarget.com/itanswers/oracle-9i-export-unsuccessful-since-patch-update/ type synonyms . exporting private type synonyms . exporting object type definitions EXP-00008: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00024: Export views not installed, please notify your DBA EXP-00000: Export terminated unsuccessfully Asked: January 24, 20068:46 AM Last updated: November 17, 20148:44 PM Related Questions Error ORA-00904 on Export Getting "EXP-00091: Exporting questionable statistics." error on Oracle export Exporting Oracle 9i tables How to export the excel file in oracle Import dump file in Oracle 11g Answer Wiki Last updated: January 24, 20062:29 PM GMT Randym1,740 pts. History Contributors Ordered by most recent Randym1,740 pts. Thanks. We'll let you know when a new response is added. You must run the CATEXP.SQL or CATALOG.SQL script to install the views and give privileages to the EXP_FULL_DATABASE role. I would start with CATEXP.SQL since that seems to be the only thing that doesn't work. Apparently that got missed in you upgrade. CATALOG.SQL eventually executes CATEXP.SQL after doing many other tasks. You must run the CATEXP.SQL or CATALOG.SQL script to install the views and give privileages to the EXP_FULL_DATABASE role. I would start with CATEXP.SQL since that seems to be the only thing that doesn't work. Apparently that got missed in you upgrade. CATALOG.SQL eventually executes CATEXP.SQL after
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips http://www.tek-tips.com/viewthread.cfm?qid=715396 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 http://www.orafaq.com/forum/t/26921/ 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 oracle error 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 Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Oracle: Oracle release - 9i and earlier oracle error 942 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 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
Rajesh Lad Messages: 5Registered: June 2004 Junior Member When i am trying to export from 9.2.0.4 oracle 9i & os windows 2000 Fowalling erroe ocured EXP nds/nds@PDONDS FILE=D:backupnds290604y.DMP FULL = Y Export: Release 9.2.0.4.0 - Production on Tue Jun 29 13:27:44 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles . exporting resource costs . exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context namespaces . exporting foreign function library names . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions EXP-00008: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00024: Export views not installed, please notify your DBA EXP-00000: Export terminated unsuccessfully Regards Rajesh Report message to a moderator Re: Export error [message #73755 is a reply to message #73751] Thu, 01 July 2004 02:57 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator login as sys and run the $ORACLE_HOME/rdbms/admin/catexp.sql Report message to a moderator Re: Export error [message #73778 is a reply to message #73755] Mon, 12 July 2004 08:47 kyle wagner Messages: 3Registered: July 2004 Junior Member I had the same error in 9i (9.2.0.5) running under windows 2k pro, and I have run catexp.sql as sys (sysdba). I then bumped my db. Now I'm getting this error: Export: Release 9.2.0.5.0 - Production on Mon Jul 12 09:46:12 20