Re: Error- Table or View does not exist.

I suspect the table was created with a case-sensitive name. You need to use quotes around the name, as well as use the proper case. The proper case does not show in the user_tables view.

"Brian Walden" <ruhockey7_at_yahoo.com> wrote in message news:9egk1e$4pvq$1_at_news3.infoave.net...
> 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 - 14:26:56 CDT