00942 Oracle Error
Contents |
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 ora-00942 oracle error GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL JOIN LIKE
Oracle Error 942 Ora-00942
MINUS NOT OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL UPDATE WHERE Oracle Advanced Oracle Cursors Oracle Exception Handling Oracle ora-942 oracle error Foreign Keys Oracle 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 Learn the cause and how to resolve the ORA-00942 error message in Oracle.
Sql Error Ora-00942
Description When 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 sql error ora-00942 table or view does not exist error occurred because the 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
thrown. The following appears in theatlassian-jira.log: 2012-10-24 17:27:47,624 ora-00942 table or view does not exist in oracle 10g main INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher 2012-10-24 17:27:47,908 main ERROR [NoModule] Error https://www.techonthenet.com/oracle/errors/ora00942.php getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:oracle:thin:@aquaman.dbserver:1521:JIRA', driverClassName='oracle.jdbc.OracleDriver', username='jira', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=20, minSize=20, initialSize=null, maxIdle=20, maxWait=30000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery=null, minEvictableTimeMillis=null, timeBetweenEvictionRunsMillis=null, poolPreparedStatements=null, testOnBorrow=null, testOnReturn=null, testWhileIdle=null, maxOpenPreparedStatements=null, numTestsPerEvictionRun=null, https://confluence.atlassian.com/display/JIRAKB/How+to+Fix+Oracle+Error+ORA-00942%3A+table+or+view+does+not+exist removeAbandonedTimeout=300, validationQueryTimeout=null, defaultCatalog=null}} org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00942: table or view does not exist ) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:1134) at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:109) at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69) at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146) at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:101) at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59) ... Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) Cause As from the error command: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existin
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of http://dba.stackexchange.com/questions/47074/getting-ora-00942-table-or-view-does-not-exist-while-table-does-exist this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes oracle error a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Getting “ORA-00942: table or view does not exist” while table does exist up vote 8 down vote favorite 1 I'm fairly new to Oracle database. I have installed Oracle Database 11g R2 on Oracle Linux 6. I table or view have successfully created a new database with dbca and connected to the database using: $ sqlplus "/ as sysdba" I successfully created a table and inserted some data and performed some selects: SQL> CREATE TABLE Instructors ( tid NUMBER(7) PRIMARY KEY, fname VARCHAR2(32), lname VARCHAR2(32), tel NUMBER(16), adrs VARCHAR2(128) ); Table created. SQL> INSERT INTO Instructors (tid, fname, lname, tel, adrs) VALUES (8431001, 'John', 'Smith', 654321, 'London'); 1 row created. SQL> SELECT count(*) FROM Instructors; COUNT(*) ---------- 1 Then I created a new user with the CONNECT privilege: SQL> CREATE USER teacher1 IDENTIFIED BY pass1; User created. SQL> GRANT CONNECT TO teacher1; Grant succeeded. Then I created a new role with appropriate object privileges: SQL> CREATE ROLE instructor; Role created. SQL> GRANT SELECT, UPDATE ON Instructors TO instructor; Grant succeeded. And granted the role to the user: SQL> GRANT instructor TO teacher1; Grant succeeded. Next I exited sqlplus with exit; and connected as the new user to test it. I logged in successfully to the database with: $ sqlplus teacher1 SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 25 03:20:50 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter password: **