Table doesn't exist

From SQLZOO
Revision as of 11:30, 19 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
schema:gisq
ORA-00942: table or view does not exist.
ORA-00942: table or view does not exist.
Error 1146 Table 'gisq.Bbc' doesn't exist
ORA-00942: table or view does not exist
ERROR: Relation "nosuchtable" does not exist
SQL0204N "GISQ.NOSUCHTABLE" is an undefined name
Msg 208 Invalid object name 'noSuchTable'
ORA-00942: table or view does not exist.
ORA-00942: table or view does not exist.
ORA-00942: table or view does not exist.

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.
 
 
SELECT * FROM Bbc
SELECT * FROM noSuchTable
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense