Table doesn't exist - Revision history

Andr3w at 13:20, 9 August 2012

2012-08-09T13:20:39Z

Connor at 11:37, 19 July 2012

2012-07-19T11:37:13Z

Connor at 11:35, 19 July 2012

2012-07-19T11:35:49Z

Connor at 11:32, 19 July 2012

2012-07-19T11:32:12Z

Connor: Created page with "

schema:gisq

ORA-00942: table o..."

2012-07-19T11:30:24Z

Created page with "<div class='err'> <div class=params>schema:gisq</div> <div class = "link e-oracle>ORA-00942: table or view does not exist.</div> <div class = "link e-access>ORA-00942: table o..."

New page

<div class='err'>
<div class=params>schema:gisq</div>
<div class = "link e-oracle>ORA-00942: table or view does not exist.</div>
<div class = "link e-access>ORA-00942: table or view does not exist.</div>
<div class = "link e-mysql>Error 1146 Table 'gisq.Bbc' doesn't exist</div>
<div class = "link e-sqlite>ORA-00942: table or view does not exist</div>
<div class = "link e-postgres>ERROR: Relation "nosuchtable" does not exist</div>
<div class = "link e-db2>SQL0204N "GISQ.NOSUCHTABLE" is an undefined name</div>
<div class = "link e-sqlserver>Msg 208 Invalid object name 'noSuchTable'</div>
<div class = "link e-ingres>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>
<h2>Problem</h2>
<p>An attempt was made to read from a table that does not exist.</p>
<p>Most likely the table name has been spelt incorrectly.</p>
<p>Possibly the table is not in the current schema or database.</p>
<h2>Solutions</h2>
<ul>
<li>Correct the spelling of the table name.</li>
</ul>
</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<source lang='sql' class='def e-mysql'>SELECT * FROM Bbc
</source>
<source lang='sql' class='def'>SELECT * FROM noSuchTable
</source>

<div class="ecomm e-mysql" style="display: none">In MySQL on LINUX the table names are case sensitive. This means that the table bbc exists but Bbc gives an error. This is a deviation from the SQL standard.</div>
<div class="ecomm e-oracle" style="display: none">
To get a list of all tables:
SELECT * FROM cat
ORDER BY TABLE_NAME</div>
<div class="ecomm e-sqlserver" style="display: none">
To get the names of all tables:
SELECT name FROM sysobjects
WHERE type='U'
ORDER BY name
</div>
</div>

← Older revision		Revision as of 13:20, 9 August 2012
Line 41:		Line 41:
	</div>		</div>
	</div>		</div>
		+	[[Category:Error]]

@@ Line 11: / Line 11: @@
 <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>
+<div>
 <h2>Problem</h2>
 <p>An attempt was made to read from a table that does not exist.</p>

@@ Line 11: / Line 11: @@
 <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>
+</div>
 <h2>Problem</h2>
 <p>An attempt was made to read from a table that does not exist.</p>