Ora-00942 Import Error
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle ora-00942 table or view does not exist in oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Java.sql.sqlexception: Ora-00942: Table Or View Does Not Exist
ORA-00942: table or view does
Ora-00942 Table Or View Does Not Exist In Oracle 10g
not exist tips Oracle Error Tips by Burleson Consulting Question: I am getting the ORA-00942 error when trying to insert into a table, where the insert is
Pl/sql: Ora-00942: Table Or View Does Not Exist
inside a PL/SQL stored procedure: How do I fix the ORA-00942 error? Answer: There are several common operations that cause a ORA-00942 error: Table owner name not specified when logged-in as a non-creator of the table. ORA-00942 on table import (imp or impdp). ORA-00942 on materialized view refresh. First, let's use the ora 00942 in informatica oerr command to see details on the ORA-00942 error: ORA-00942 table or view does not existCause: 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. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.Action: Check each of the following: - the spelling of the table or view name. - that a view is not specified where a table is required. - that an existing table or view name exists. - Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.Also, if attempting to ac
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies ora-00942 table or view does not exist hibernate of this site About Us Learn more about Stack Overflow the company ora-00942 procedure Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users table or view does not exist oracle sql developer Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a http://www.dba-oracle.com/sf_ora_00942_table_or_view_does_not_exist.htm minute: Sign up ORA-00942: table or view does not exist error using impdp up vote 0 down vote favorite I've been provided with a Oracle database dump which I'm attempting to import using the following: impdp myuser/myuser DUMPFILE=/u01/app/oracle/oradata/dumpfile.dmp FULL=y LOGFILE=/u01/app/oracle/oradata/dumplog.log The output is Import: Release 12.1.0.1.0 - Production on Fri May 1 09:46:59 2015 Copyright (c) 1982, 2013, Oracle and/or its affiliates. http://stackoverflow.com/questions/29984214/ora-00942-table-or-view-does-not-exist-error-using-impdp All rights reserved. UDI-00942: operation generated ORACLE error 942 ORA-00942: table or view does not exist Is there anyway I can find out what the problem is or get more information? The user myuser has all privileges. oracle datapump impdp share|improve this question asked May 1 '15 at 9:08 Loftx 1,03932042 1 i see this is a 12c database, is it multitenant? if so i would guess the problem is that the import doesn't know which PDB to import the data into –davegreen100 May 1 '15 at 9:15 @davegreen100 - this is a non-CDB database so I'm assuming that's not the case, but I'm not hugely familiar with Oracle so if you think there's anything I should check or run to confirm this please let me know. –Loftx May 1 '15 at 9:23 i haven't done alot with 12c, but i think running SELECT * FROM V$PDBS will tell you if there are any pluggable databases. could you post the contents of the impdp logfile –davegreen100 May 1 '15 at 9:38 Thanks again - I th
thrown. The following appears in theatlassian-jira.log: 2012-10-24 17:27:47,624 main INFO table or [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher 2012-10-24 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, table or view 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.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.process