Difference between revisions of "Table doesn't exist"
From SQLZOO
| Line 11: | Line 11: | ||
<div class = "link e-mimer">ORA-00942: table or view does not exist.</div> | <div class = "link e-mimer">ORA-00942: table or view does not exist.</div> | ||
<div class = "link e-sybase">ORA-00942: table or view does not exist.</div> | <div class = "link e-sybase">ORA-00942: table or view does not exist.</div> | ||
| − | <div> | + | </div> |
<h2>Problem</h2> | <h2>Problem</h2> | ||
<p>An attempt was made to read from a table that does not exist.</p> | <p>An attempt was made to read from a table that does not exist.</p> | ||
Revision as of 11:35, 19 July 2012
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.
</div>
SELECT * FROM Bbc
SELECT * FROM noSuchTable
</div>
