Re: Error- Table or View does not exist.

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 22 May 2001 22:57:58 -0700
Message-ID: <3B0B5166.2D445CB@exesolutions.com>

Brian Walden wrote:

> Using SQL Plus, why is it that when I do "SELECT table_name FROM
> user_tables" i can see a list of tables but when I do a "SELECT * FROM
> tablename" where tablename is a table displayed in the first result set , i
> get an error "Table or View does not exits"
>
> Any help?
> Thanks.

There is no table named tablename.

I'm not exactly sure why you would even assume that such an entity exits nor what you hoped to accomplish by your query if it did exist.

Please explain what you are trying to do and perhaps someone can give you some pointers.

Daniel A. Morgan Received on Wed May 23 2001 - 00:57:58 CDT