StackOverflow Questions for Tag: ora-00942

Clomez

Reputation: 1522

ORA-00942: table or view does not exist with huge query

oracle-databaseoracle11gora-00942

Score: 0

Answers: 1

user2102665

Reputation: 505

Query DBA_TABLES and USER_TABLES in PL SQL cursor

oracle-databasecursorora-00942

Score: 2

Answers: 2

waltwood

Reputation: 957

Multi-Schema Privileges for a Table Trigger in an Oracle Database

databaseoracle-databasetriggersoracle10gora-00942

Score: 4

Answers: 3

VinceJS

Reputation: 1274

Is there a good workaround to the Oracle IMPDP REMAP_SCHEMA issue with triggers (ORA-39083, ORA-00942)?

oracle-databaseschemaremapora-00942impdp

Score: 10

Answers: 2

SQL_rookie

Reputation: 153

Dynamic SQL / Exception Handling -00942 - Oracle PL/SQL

plsqlexceptionoracle-sqldeveloperdynamic-sqlora-00942

Score: 1

Answers: 1

Jinsuk Oh

Reputation: 63

How to use DBA_JOBS in procedure

databaseoracle-databaseora-00942

Score: 0

Answers: 2

Mahmoud Elkashab

Reputation: 1

ora-00942 even i create table in my schema

oracle-databaseschemaora-00942

Score: 0

Answers: 3

Tpk43

Reputation: 331

Table exists in stored procedure while used in select but not when Used in Insert statement

oracle-databaseoracle11gora-00942

Score: 1

Answers: 1

user2102665

Reputation: 505

Rebuild index through loop in PLSQL

indexingplsqlfor-in-looprebuildora-00942

Score: 2

Answers: 1

rovsen

Reputation: 5022

"ORA-00942: table or view does not exist" for mixed case table and columns

oracle-databasetoadora-00942quoted-identifier

Score: 0

Answers: 1

fnr

Reputation: 9667

LEFT JOIN on multiple tables ERROR! (Table or view does not exist)

sqloracle-databasejoinora-00942

Score: 1

Answers: 1

Thorsten

Reputation: 13181

Accessing another user's table within an Oracle Stored Procedure

oracle-databasestored-proceduresprivilegesora-00942

Score: 17

Answers: 1

Victor

Reputation: 17107

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

sqloracle-databaseoracle9iora-00942

Score: 38

Answers: 5

damon

Reputation: 15128

I'm using Django with a remote Oracle database, and getting a "Table does not exist" error

djangooracle-databasemultiple-databasesora-00942

Score: 2

Answers: 1

Greener

Reputation: 477

Oracle view with multiple join is only recognize when use a quotes around - why?

sqloracle-databaseviewora-00942

Score: 0

Answers: 2

Chad

Reputation: 24699

'ORA-00942: table or view does not exist' only when running within a Stored procedure

oracle-databasestored-proceduresplsqlora-00942

Score: 3

Answers: 4

d_S97

Reputation: 21

ORA-00942: table or view does not exist when Selecting something from a table from a heterogenous service

sql-serverdatabaseoracle-databaseheterogeneousora-00942

Score: 0

Answers: 1

HJW

Reputation: 23443

ORA-00942: Can select from "schema.table" but not "table"?

oracle-databaseora-00942

Score: 4

Answers: 3

Itsik Mauyhas

Reputation: 4002

Query synonyms table at oracle via Java-jdbc

javaoracle-databasejdbcora-00942

Score: 0

Answers: 0

erickson

Reputation: 269847

Why doesn't Oracle tell you WHICH table or view does not exist?

sqldatabaseoracle-databaseora-00942

Score: 66

Answers: 8

PreviousPage 2Next

StackOverflow Questions for Tag: ora-00942

ORA-00942: table or view does not exist with huge query

Query DBA_TABLES and USER_TABLES in PL SQL cursor

Multi-Schema Privileges for a Table Trigger in an Oracle Database

Is there a good workaround to the Oracle IMPDP REMAP_SCHEMA issue with triggers (ORA-39083, ORA-00942)?

Dynamic SQL / Exception Handling -00942 - Oracle PL/SQL

How to use DBA_JOBS in procedure

ora-00942 even i create table in my schema

Table exists in stored procedure while used in select but not when Used in Insert statement

Rebuild index through loop in PLSQL

&quot;ORA-00942: table or view does not exist&quot; for mixed case table and columns

LEFT JOIN on multiple tables ERROR! (Table or view does not exist)

Accessing another user&#39;s table within an Oracle Stored Procedure

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

I&#39;m using Django with a remote Oracle database, and getting a &quot;Table does not exist&quot; error

Oracle view with multiple join is only recognize when use a quotes around - why?

&#39;ORA-00942: table or view does not exist&#39; only when running within a Stored procedure

ORA-00942: table or view does not exist when Selecting something from a table from a heterogenous service

ORA-00942: Can select from &quot;schema.table&quot; but not &quot;table&quot;?

Query synonyms table at oracle via Java-jdbc

Why doesn&#39;t Oracle tell you WHICH table or view does not exist?

"ORA-00942: table or view does not exist" for mixed case table and columns

Accessing another user's table within an Oracle Stored Procedure

I'm using Django with a remote Oracle database, and getting a "Table does not exist" error

'ORA-00942: table or view does not exist' only when running within a Stored procedure

ORA-00942: Can select from "schema.table" but not "table"?

Why doesn't Oracle tell you WHICH table or view does not exist?