Re: Can Not find table error

In article <b87c466c.0306180808.31d96386_at_posting.google.com>, spebola_at_swbell.net says...
> > Misread something here - you are able to do everything to the table in
> > sqlplus but your VB program, connecting to the same account, cannot - I
> > wonder if there is some case-sensitivity issue here.
> >
> > If you create a table like this:
> > create table fred (x number);
> > the table will appear in the data disctionary as FRED
> >
> > But:
> > create table "fred" (x number);
> > the table will appear in the data disctionary as fred and to acces it
> > you will need to e.g.
> >
> > select * from "fred";
> >
> > Could a variation of this be your problem?
> >
> > hth
> >
> > cheers
>
>
> I connected to the database via SQLPlus worksheet as the user Id and
> password I am using in the vb.net project and ran the suggested query
> and CONT does appear (along with 1345 other rows).
>
> I used create table Cont to create the table and have tried SELECT *
> FROM Cont and SELECT * FROM CONT and neither works. I get ORA-00942
> Table or view does not exist. I did not use the double quotes
> anywhere in the create table sql.
>
> I have also tried both the Microsoft native data provider for oracle
> and Oracle's data provider for .Net with the same results.
>
> It must be a security issue, but I have granted all priviledges to the
> user ID.
>
> I find the schema for CONT in the tree (in OEM) under the node
> schema/sys/table and I was expecting to find something under storage
> but there is nothing for CONT.
>
> Thanks for the comments.
>

Hmm.. illogical captain ...

when you do your select from user_objects, does the name of your table appear in upper case? And is the object_type listed as table?

-- 

jeremy
['75 RD250A] | ['02 Fazer 600 in blue]