That was the problem. Thanks.
Alan <alanshein_at_erols.com> wrote in message
news:9eh2ri$ndk$1_at_bob.news.rcn.net...
> 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 - 15:18:20 CDT
