Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can Not find table error
> 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. Received on Wed Jun 18 2003 - 11:08:49 CDT