Ora-00942 Error In Sql Developer
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.sql.sqlexception: ora-00942: table or view does not exist Java Clipart Techie Humor Advertisement Oracle Basics ALIASES AND AND &
Table Or View Does Not Exist Oracle Sql Developer
OR BETWEEN COMPARISON OPERATORS DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS
Ora-00942 Table Or View Does Not Exist In Oracle 10g
NOT NULL IS NULL JOIN LIKE MINUS NOT OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL UPDATE WHERE Oracle Advanced Oracle Cursors Oracle Exception Handling
Ora-00942 Table Or View Does Not Exist Hibernate
Oracle 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 Error Message Learn the cause and how to resolve the ORA-00942 error message in Oracle. Description When you encounter an ORA-00942 error, the following error message will appear: ORA-00942: table or ora-00942 table or view does not exist informatica 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 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
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 this site About ora-00942: table or view does not exist sap Us Learn more about Stack Overflow the company Business Learn more about hiring pl/sql: ora-00942: table or view does not exist developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange ora-00942 procedure 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 a minute: Sign up Here's how https://www.techonthenet.com/oracle/errors/ora00942.php 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 have successfully created a new database with dbca and http://dba.stackexchange.com/questions/47074/getting-ora-00942-table-or-view-does-not-exist-while-table-does-exist 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: ***** Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining
thrown. The following appears in table or theatlassian-jira.log: 2012-10-24 17:27:47,624 main INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher 2012-10-24 17:27:47,908 main ERROR [NoModule] Error getting datasource table or view 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, 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.Conn
is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: Stored Procedure: ora-00942 table or view does not exist Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-04-11,03:59 #1 GraceCheong View Profile View Forum Posts Registered User Join Date Oct 2011 Posts 3 Unanswered: Stored Procedure: ora-00942 table or view does not exist Hi all, I'm new to oracle SQL Developer, currently using Oracle 11g R2. I need to write Stored Procedure to retrieve data and work with Crystal Report. I just started to leaned this a week ago. I having a problem when I compile the Stored Procedure, it appears the errors: Error(8,14): PL/SQL: SQL Statement ignored Error(8,58): PL/SQL: ORA-00942: table or view does not exist My Stored Procedure coding: create or replace PROCEDURE TEST3_SP AS PO_Num VARCHAR2(9); CURSOR PO_Crs IS SELECT erpln.ttdpur400223.t$orno FROM erpln.ttdpur400223; BEGIN OPEN po_crs; LOOP FETCH PO_Crs INTO PO_Num; EXIT WHEN PO_Crs%NOTFOUND; DBMS_OUTPUT.PUT_LINE(PO_Num); END LOOP; CLOSE PO_Crs; END TEST3_SP; It works fine at SQL Worksheet to the SQL Command (SELECT erpln.ttdpur400223.t$orno FROM erpln.ttdpur400223) and returned values. Does anyone encounterd this error before? How to solve it? URGENT!!! Best Regards, Grace Reply With Quote 10-04-11,06:56 #2 Littlefoot View Profile View Forum Posts Lost Boy Join Date Jan 2004 Location Croatia, Europe Posts 4,090 Provided Answers: 4 If you don't own the table, then its owner has to grant you privileges to access it. For example, he granted SELECT to you. However: if he granted it via a role, bad news: privileges acquired via roles won't work in PL/SQL. Ask the owner to grant these privileges directly to you. Reply With Quote 10-05-11,05:13 #3 GraceCheong View Profile View For