Oracle Error Code 00942
Contents |
thrown. The following appears table or view does not exist oracle sql developer in theatlassian-jira.log: 2012-10-24 17:27:47,624 main INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher 2012-10-24
Ora-00942 Table Or View Does Not Exist Hibernate
17:27:47,908 main ERROR [NoModule] Error 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, ora-00942 table or view does not exist in oracle 10g 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.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 all
productResults.length + resourceResults.length > 0 ? 'See all Search Results' : 'Full site search'}} > > CA Support Online > Support by Product > Support by Product When using a query in CA-Aion, why do I receive a “Oracle error 942: table or view does not exist"? Document ID:TEC521753 Last Modified Date:09/01/2016 {{active ? 'Hide'
Pl/sql: Ora-00942: Table Or View Does Not Exist
: 'Show'}} Technical Document Details Products CA Aion Business Rules Expert Releases CA
Ora-00942 In Informatica
Aion Business Rules Expert:Release:11.0 Components CA AION BUSINESS RULES EXPERT:AIONBR Question: If I receive a "Oracle error 942: table or view ora-00942 procedure does not exist", how can I resolve this? Does it have anything to do with the CA Aion code or CA Aion IDE itself? Answer: The cause or reason for Oracle error 942 message is https://confluence.atlassian.com/display/JIRAKB/How+to+Fix+Oracle+Error+ORA-00942%3A+table+or+view+does+not+exist because Oracle tries to execute an SQL statement that references a table or view that either does not exist, or because a synonym that is not allowed here was used, or because you do not have access rights to the particular object. Other possible cause is that the table or view belongs to another schema and you didn't reference the table by the schema name, or a view was referenced http://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec521753.html where a table is required.Depending on the cause of the problem, there are several resolutions or remedies to resolve this error. Due to there being several possible reasons that may cause the error, there are several actions or steps that you can take to identify where the error is and take the appropriate workaround or solution. Check if user tables and views exist in Oracle by querying the data dictionary by executing the following SQL statement: select * from all_objects where object_type in (`TABLE','VIEW') and object_name = `OBJECT_NAME`; Replace OBJECT_NAME with the name of the table or view that you want to verify its existence. If the table or view exists, check and verify if the user has the necessary permissions and rights to read and access (i.e. select) from the table, as certain privileges may be required to access the table. In this case, you will need to have the owner of the table or view, or a Oracle DBA grant the appropriate privileges, permissions or rights to this object. Note that when selecting from a system view (such as v$session) the privilege or access rights to select from the view must be granted to the user directly and not via a role. This is the
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 Us Learn more about Stack Overflow the company Business http://stackoverflow.com/questions/16129912/sql-error-ora-00942-table-or-view-does-not-exist Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just http://ccm.net/faq/3090-ora-00942-table-or-view-does-not-exist like you, helping each other. Join them; it only takes a minute: Sign up SQL Error: ORA-00942 table or view does not exist up vote 3 down vote favorite I use SQL developer and i made a table or connection to my database with the system user, after I created a user and made a another connection with that user with all needed privileges. But when I try to proceed following I get the SQL Error ORA-00942 table or view does not exist.: INSERT INTO customer (c_id,name,surname) VALUES ('1','Micheal','Jackson') sql oracle11g share|improve this question edited Jan 19 '14 at 9:20 a_horse_with_no_name 187k24235312 asked Apr 21 '13 at 9:52 user2304042 21113 add a comment| 4 table or view Answers 4 active oldest votes up vote 5 down vote either the user doesn't have privileges needed to see the table, the table doesn't exist or you are running the query in the wrong schema does the table exist? select owner, object_name from dba_objects where object_name = any ('CUSTOMER','customer'); what privileges did you grant? grant select, insert on customer to user; are you running the query against the owner from the first query? share|improve this answer edited Apr 21 '13 at 10:30 a_horse_with_no_name 187k24235312 answered Apr 21 '13 at 9:58 rs' 1513 1 dba_objects is not accessible for a regular user. You should use all_objects instead. –a_horse_with_no_name Apr 21 '13 at 10:30 Thanks a lot for your interest, Ive executed the first query to see the owner of the 'customer' table, I got the result "0 rows selected". so that means the user that I created does not have needed priviliges I guess ? –user2304042 Apr 23 '13 at 9:05 add a comment| up vote 3 down vote You cannot directly access the table with the name 'customer'. Either it should be 'user1.customer' or create a synonym 'customer' for user2 pointing to 'user1.customer'. hope this helps.. share|improve this answer answered Jun 27 '13 at 16:58 user2529066 312 add a comment| up vote 1 down vote Here is an answer
Indonesia Login Subscribe to our newsletter Search Home Forum Ask a question Latest questions Windows Mac Linux Internet Video Games Software Hardware Mobile Network Virus Café How To Download Ask a question Windows Software Mac Software Linux Software Android Apps BlackBerry Apps iPhone Apps Windows Phone Apps News Encyclopedia Home How To Programming Databases Oracle ORA-00942: table or view does not exist Ask a question October 2016 Does ORA-00942 table or view not exist in Oracle? No problem, here is a quick solution to it. This error may be because an unauthorised synonym or any expression is used instead of a table name. One must verify the following conditions before troubleshooting queries. Name of the view and tables used in Oracle with different table names can also show an error message. The table exists because of the table name view in Oracle. There are some special privileges which are granted to users so the database administrator can be contacted later. The below article will illustrate reasons and solutions for viewing a table if it doesn't exist in Oracle. Issue Solution Note that Issue If you encounter the following error message: a table or view entered does not exist, or unauthorised synonym was used, or an expression of view was used instead of a table name. Solution You must verify the following items: the name of the view or the tables used that name of a view is used instead of a table name the name of the view or the table exists. To verify the existence of view, table or synonym: SELECT * FROM DBA_TABLES WHERE TABLE_NAME = 'table_name'; SELECT * FROM DBA_SYNONYM WHERE SYNONYM_NAME = 'synonym_name'; SELECT * FROM DBA_VIEWS WHERE VIEW_NAME = 'view_name'; Note that In the case that the table needs to be created or if user or application privileges are needed to access the table, please contact the database Administrator. Related