Re: Error- Table or View does not exist.

Lets say that there is a table called "MyTable" that shows up in the result set when i call "SELECT table_name FROM user_tables" This tells me that there is a table called MyTable.

Now, when I call "SELECT * FROM MyTable" i get an error that says "table or view does not exist"

I am confused why the first query would indicate that there is a table called MyTable and the second query says that no such table or view exists.

Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote in message news:3B0B5166.2D445CB_at_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 - 10:11:57 CDT