Top "Ora-00942" questions

Table or view does not exist.

ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)

When I have a sql statement like select * from table1, it works great, but as soon as I put it …

Read More
sql oracle oracle9i ora-00942
Spring Batch Framework - Auto create Batch Table

I just created a batch job using Spring Batch framework, but I don't have Database privileges to run CREATE SQL. …

Read More
database spring spring-batch privileges ora-00942
Accessing another user's table within an Oracle Stored Procedure

I'm writing a stored procedure to copy data from one user's table to another schema. Basically, it is a series …

Read More
oracle stored-procedures privileges ora-00942
Is there a good workaround to the Oracle IMPDP REMAP_SCHEMA issue with triggers (ORA-39083, ORA-00942)?

One can use the Oracle data pump import tool (IMPDP.EXE) to import one schema into another using the REMAP_…

Read More
oracle schema remap ora-00942 impdp
Oracle dba_data_files table doesn't exist

I've been trying to access the dba_data_files table to see whether the autoextend is turned on for my …

Read More
oracle ora-00942 data-files
ORACLE :Are grants removed when an object is dropped?

I currently have 2 schemas, A and B. B has a table, and A executes selects inserts and updates on it. …

Read More
oracle rename grant ora-00942 sql-drop
Oracle Create View issue

I am logged in as the dba account and I want to create a view in User1's schema, but …

Read More
sql oracle view grant ora-00942
Oracle - Unable to drop tables

This question is related to the one I posted yesterday but with further implications. The situation is: I'm unable to …

Read More
oracle oracle10g ora-00942 drop-table