Re: Error- Table or View does not exist.

Brian Walden wrote:

> 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
> > > >
> > >
> > >
> >
> >

Then let me give you some advise. Drop that table and recreate it properly. This will cause you no end of misery until it is replaced.

Daniel A. Morgan Received on Wed May 23 2001 - 21:11:32 CDT