Ora 00942 Error In
Contents |
thrown. The following appears in theatlassian-jira.log: ora-00942 in informatica 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
Ora-00942 Table Or View Does Not Exist In Oracle 10g
[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, timeBetweenEvictionRunsMillis=null, poolPreparedStatements=null, testOnBorrow=null, testOnReturn=null,
Pl/sql: Ora-00942: Table Or View Does Not Exist
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 allowed here was used, or a view was re
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 ora-00942 procedure Learn more about Stack Overflow the company Business Learn more about hiring developers or
Ora-00942: Table Or View Does Not Exist Sap
posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow table or view does not exist oracle sql developer Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL Error: ORA-00942 table or view does not exist https://confluence.atlassian.com/display/JIRAKB/How+to+Fix+Oracle+Error+ORA-00942%3A+table+or+view+does+not+exist up vote 3 down vote favorite I use SQL developer and i made a 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 http://stackoverflow.com/questions/16129912/sql-error-ora-00942-table-or-view-does-not-exist 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 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
You Can Get ORA-00942 Errors with Flashback Query By Chris Saxon-Oracle on Jan 19, 2016 I've recently been playing with one of my favorite Oracle features: https://blogs.oracle.com/sql/entry/why_you_can_get_ora Flashback. More specifically, Flashback Data Archive. lightning last year by oompa123 (CC BY 3.0) This extends the power of flashback query. Normally you can only use this to query as far back as your undo allows. With Flashback Data Archive (FBA), Oracle keeps a permanent store of a table's history (up to the retention period). So using this you can run "as of" table or queries over a larger period. This enables you to see what was in a table days, months or even years ago! You can also view all the changes to a table between two times. Enabling FBA is a quick and easy way to audit data changes. Even better, unlike standard flashback query, you can go back to a time before you ran DDL table or view against the table. And the best part? As of 12c it's FREE!* But I found myself hitting a strange error. After creating the archive and adding a table to it, I was getting "ORA-00942: table or view does not exist" errors: SQL> select * from products as of timestamp sysdate - interval '1' minute; select * from products as of timestamp sysdate - interval '1' minute * ERROR at line 1: ORA-00942: table or view does not exist Strange. The table itself existed. So what's going wrong? How Oracle enables flashback archive on a table When you add a table to a flashback archive, Oracle creates extra tables in the background for you. It uses these to construct historic versions of the data. You can find one of these tables with the following query: select * from sys.dba_flashback_archive_tables; TABLE_NAME OWNER_NAME FLASHBACK_ARCHIVE_NA ARCHIVE_TABLE_NAME STATUS ------------ ---------- -------------------- -------------------- ------------- PRODUCTS CHRIS