Exp-00056 Oracle Error 942 Encountered
Contents |
Newbie Group: Members Posts: 5 Joined: 30-December 05 From: Coimbatore Member No.: 3,469 exp 00008 oracle error 904 encountered Hi, While Exporting database.I am getting Problem.Kindly do the needful.Oracle Server:9.2.0.6.0Orcalse Client:
Oracle Error 942 Encountered Import
10.1.0.2.0Username :test@ProdExport: Release 10.1.0.2.0 - Production on Fri Dec 30 10:23:37 2005Copyright © 1982, 2004, Oracle. All rights reserved.Password:Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ProductionJServer Release 9.2.0.6.0 - ProductionEnter array fetch buffer size: 4096 >Export file: EXPDAT.DMP > test.dmp(2)U(sers), or (3)T(ables): (2)U >Export grants (yes/no): yes >Export table data (yes/no): yes >Compress extents (yes/no): yes >Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character setserver uses WE8ISO8859P1 character set (possible charset conversion)EXP-00056: ORACLE error 942 encounteredORA-00942: table or view does not existEXP-00000: Export terminated unsuccessfully maxdbo View Member Profile Dec 30 2005, 11:53 PM Post #2 Advanced Member Group: Members Posts: 99 Joined: 21-July 05 Member No.: 2,556 hi QUOTE While Exporting database.I am getting Problemwhat do you want to export ? IS this user attached to any tablespace ? does he own any objects ? If it is full db export does the user have sufficient privileges ? Please confirm. try setting ORACLE_HOME before export regardsMAX ăг∂üή View Member Profile Dec 31 2005, 12:42 AM Post #3 Advanced Member Group: Members Posts: 81 Joined: 22-November 05 From: India Member No.: 3,304 QUOTE Oracle Server:9.2.0.6.0Orcalse Client: 10.1.0.2.0If exp and imp are used to export data from an Oracle database with a different version than the database in which is imported, then the following rules apply: 1. exp must be of the lower version 2. imp must match the target version or be a higher version. Try to use 9.2.0.6.0 client. -------------------- Cheers,ăг∂üή « Next Oldest · Oracle Forum · Next Newest » 1 User(s) are reading this topic (1 Guests and 0 Anonymous Users) 0 Members: Forum Home Search Help Oracle |-- Oracle Forum Display Mode: Standard · Switch to: Linear+ · Switch to: Outline Track this topic · Email
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 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 > EXP-00056: ORACLE error 942 encountered Want to Advertise Here? Solved EXP-00056: ORACLE error http://dbaforums.org/oracle/index.php?showtopic=3260 942 encountered Posted on 2009-09-24 Oracle Database 1 Verified Solution 6 Comments 1,874 Views Last Modified: 2013-12-19 Here is just a sample for single table export (however, the goal is to export data from very old database for two owners). Catexp.sql has been run (there are some ORA-01921 error in it I have log https://www.experts-exchange.com/questions/24758690/EXP-00056-ORACLE-error-942-encountered.html and can add to this post if it needed) $exp user/password file=test.dmp tables=abc_table Export: Release 8.1.7.4.0 - Production on Thu Sep 24 08:44:00 2009 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production JServer Release 8.1.7.4.0 - Production Export done in US7ASCII character set and US7ASCII NCHAR character set EXP-00056: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00000: Export terminated unsuccessfully 0 Question by:sevior Facebook Twitter LinkedIn Google Best Solution bysevior Ran c0800050.sql as 'SYSDBA', errors like "ORA-00942: table or view does not exist" showed many times, however after script has been "completed" I was able to run export. Go to Solution 6 Comments LVL 40 Overall: Level 40 Oracle Database 32 Message Expert Comment by:mrjoltcola2009-09-24 Verify that abc_table exists under the "user" schema. Try a simple full schema export instead of a table export and see which tables are exported. exp user/password file=test.dmp 0 Message Author Comment by:sevior2009-09-24 Yes
temporary tablespace usage nid failure and open_cursors Standby roll forward using RMAN incremental backup Set trace on user sessions Oracle 10g - ORA-01031 insufficient privileges ORA-00942/ORA-00904/EXP-00056 with http://www.dbapundits.com/blog/oracle-ora-errors/ora-00942-ora-00904-exp-00056-with-oracle-exp/ Oracle exp dbms_system.ksdwrt–Write messages to Oracle alert log « Oracle 10g - ORA-01031 insufficient privileges dbms_system.ksdwrt–Write messages to Oracle alert log » ORA-00942/ORA-00904/EXP-00056 with Oracle exp Oracle export utility when used to export from a lower version of database may not work due to compatibility issues as the export utility expects a set of oracle error views that are not present in the database. Even patchset difference between the exp utility and the database can lead to similar issues. The best bet to deal with the issue is to use the lowest version available at the source/target database. If you are using Oracle client, opt for the lowest version available oracle error 942 for taking the export. The errors differ based on the version difference between exp utility and the database, the following errors are possible: 9i client against lower versions of 9i database or 10g clients against 9.2.0.4 database can cause the following messages in the export log: EXP-00056 Oracle error 942 encountered ORA-00942 table or view does not exist EXP-00000 Export terminated unsuccessfully On some 9i R2 versions, the error may be reported as below: 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 9.2.0.6 export client against a 9.2.0.5 can cause the following messages in the export log during the export of partitioned tables. EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 48: PLS-00302: component ‘CHECK_MATCH_TEMPLATE' must be declared ORA-06550: line 1, column 14: PL/SQL: Statement ignored 10.2.0.4 client against a 10.2.0.3 database can cause the following messages in the export log during the