Eine Einführung in

SQL

ORA-00942: table or view does not exist

Oracle

Problem

An attempt was made to read from a table that does not exist.

Most likely the table name has been spelt incorrectly.

Possibly the table is not in the current schema or database.

Solutions

  • Correct the spelling of the table name.


Specific to Oracle

To get a list of all tables:

SELECT * FROM cat
ORDER BY TABLE_NAME