ORA-00942 🗃️ SQL

ORA-00942: table or view does not exist

Oracle can’t see the table — it doesn’t exist, is in another schema, or you lack privileges on it.

Seen on: SQL

Meaning

Oracle reports missing privileges the same way as missing objects. Tables in other schemas need SCHEMA.TABLE or a synonym, and quoted mixed-case names must keep their quotes.

Common causes

  • Object in another schema without prefix/synonym
  • No SELECT grant
  • Quoted mixed-case name ("Orders")
  • Not created yet

⚡ Quick fix

  1. Prefix the schema: APP.ORDERS
  2. Grant privileges: GRANT SELECT ON app.orders TO reporting
  3. Avoid quoted identifiers

Detailed fix by platform

SQL

  1. SELECT owner, table_name FROM all_tables WHERE table_name = 'ORDERS';

How to diagnose

  1. Owner — Which schema owns it?
  2. Grant — Privileges?

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.