Oracle Error ORA-00942: Table or View Does Not Exist (Fix Guide)

The Error Message

What Causes Oracle ORA-00942?

ORA-00942 occurs when Oracle cannot find the table or view you referenced. This is often a permissions issue — the table exists but you don't have access.

Common Causes

How to Fix It

Step 1: Use schema-prefixed name

Prefix the table name with the schema (owner) name.

-- Instead of:
SELECT * FROM employees;

-- Use:
SELECT * FROM hr.employees;

Step 2: Check if table exists

ALL_TABLES shows tables you have access to. USER_TABLES shows only your own tables.

-- Search all tables you can see:
SELECT owner, table_name
FROM all_tables
WHERE table_name LIKE '%EMPLOYEE%';

-- Check your own tables:
SELECT table_name FROM user_tables;

Step 3: Grant access

Either grant direct access or create a synonym so users can reference it without the schema prefix.

-- As the table owner:
GRANT SELECT ON hr.employees TO your_user;

-- Or create a public synonym:
CREATE PUBLIC SYNONYM employees FOR hr.employees;

Step 4: Check grants and synonyms

Verify what privileges you have and whether a synonym exists.

-- Check your privileges:
SELECT * FROM user_tab_privs
WHERE table_name = 'EMPLOYEES';

-- Check synonyms:
SELECT * FROM all_synonyms
WHERE synonym_name = 'EMPLOYEES';

How to Prevent This Error

Always use schema-prefixed table names in application code. Create synonyms for frequently accessed cross-schema tables. Use roles to manage privileges instead of granting to individual users.

Fix Oracle Errors with AI2SQL

Instead of debugging SQL syntax manually, describe what you need in plain English and let AI2SQL generate the correct query for Oracle.

Frequently Asked Questions