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: ORACLE error 942 encountered , ORA-00942 Once while
Ora-00942 Error
visiting OTN , i found a user is facing the below error while performing table or view does not exist oracle sql developer 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,
Ora-00942 Table Or View Does Not Exist In Oracle 10g
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 ora 00942 table or view does not exist informatica error 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 pl/sql: ora-00942: table or view does not exist 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
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java Clipart Techie Humor Advertisement Oracle Basics ALIASES AND AND & OR BETWEEN COMPARISON OPERATORS DELETE DISTINCT EXISTS FROM GROUP BY
Java.sql.sqlsyntaxerrorexception: Ora-00942: Table Or View Does Not Exist
HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL JOIN LIKE MINUS NOT ora-00942 table or view does not exist in oracle 12c OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL UPDATE WHERE Oracle Advanced Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle
Sql Error: 942, Sqlstate: 42000
Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions Oracle / PLSQL: ORA-00942 Error Message Learn the cause and how to resolve the ORA-00942 error message in Oracle. Description When http://neeraj-dba.blogspot.com/2011/10/exp-00008-oracle-error-942-encountered.html you encounter an ORA-00942 error, the following error message will appear: ORA-00942: table or view does not exist Cause You tried to execute a SQL statement that references a table or view that either does not exist, that you do not have access to, or that belongs to another schema and you didn't reference the table by the schema name. Resolution The option(s) to resolve this Oracle error are: Option #1 If this error occurred because the https://www.techonthenet.com/oracle/errors/ora00942.php table or view does not exist, you will need to create the table or view. You can check to see if the table exists in Oracle by executing the following SQL statement: SELECT * FROM all_objects WHERE object_type IN ('TABLE','VIEW') AND object_name = 'OBJECT_NAME'; For example, if you are looking for a suppliers table, you would execute: SELECT * FROM all_objects WHERE object_type IN ('TABLE','VIEW') AND object_name = 'SUPPLIERS'; Option #2 If this error occurred because you do not have access to the table or view, you will need to have the owner of the table/view, or a DBA grant you the appropriate privileges to this object. Option #3 If this error occurred because the table/view belongs to another schema and you didn't reference the table by the schema name, you will need to rewrite your SQL to include the schema name. For example, you may have executed the following SQL statement: SELECT * FROM suppliers; But the suppliers table is not owned by you, but rather, it is owned by a schema called app, you could fix your SQL as follows: SELECT * FROM app.suppliers; If you do not know what schema the suppliers table/view belongs to, you can execute the following SQL to find out: SELECT owner FROM all_objects WHERE object_type IN ('TABLE','VIEW') AND object_name = 'SUPPLIERS'; This will return the schema name who owns the suppliers table.
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
http://www.dba-oracle.com/t_exp_00056_ora_942_export_database_db_link.htm EXP-00056: ORACLE error 942 encountered with db_link Question: I tried to export the table from client database 8.1.7 using DBLINK from our database 10.1.0.3 and got this error "EXP-00056: ORACLE error 942 encountered". Please help out. Export: Release 10.1.0.3.0 - Production on Wed Oct 12 10:27:38 2005 Copyright © 1982, 2004, Oracle. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production Enter array fetch buffer table or size: 4096 > Export file: expdat.dmp > test.dmp (2)U(sers), or (3)T(ables): (2)U > 3 Export table data (yes/no): yes > Compress extents (yes/no): yes > EXP-00056: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00000: Export terminated unsuccessfully Answer by Edward Stoever: I have always used exp as a single command, not interactively. It is claiming the table does not exist, but I don't see it asking for a table table or view - yet. (weird) Why not try it as a single command.... like this: exp scott/tiger file=emp.dmp tables=(emp,dept) I think that you are breaking the second rule there, and you should be exporting using an 8.1.7 client. The Oracle documentation notes: Whenever you are moving data between different releases of the Oracle database, the following basic rules apply: * The Import utility and the database to which data is being imported (the target database) must be the same version. * The version of the Export utility must be equal to the earliest version of the source or target database.For example, to create an export file for an import into a later release database, use a version of the Export utility that is equal to the source database. Conversely, to create an export file for an import into an earlier release database, use a version of the Export utility that is equal to the version of the target database. Get the Complete Oracle Utility Information The landmark book "Advanced Oracle Utilities The Definitive Reference" contains over 600 pages of filled with valuable information on Oracle's secret utilities. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.