Re: Schema Access

You didn't by any chance stick quotation marks around the table names, did you? If you do, Oracle takes them literally, mixed case and all:

SQL> create table "Blah" (col1 char(5));

Table created.

SQL> select * from blah;
select * from blah

              *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> select * from "Blah";

no rows selected (No rows is fine -I didn't insert any- but at least it knows the table I'm talking about)

The better syntax is just

create table blah (col1 char(5));

Then select * from blah or select * from BLAH or select * from bLaH all work equally well.

You get this problem a lot when you migrate Access databases across to Oracle, too.

Regards
HJR "Yuel Adorno" <yuel_at_contrada.com.au> wrote in message news:c44Z8.453280$o66.1221259_at_news-server.bigpond.net.au...
> I'm confused!
>
> Although I have generated my tables in my own schema I can't
> access my table => ORA-00942 table or view does not exist..
>
> What's wrong under Oracle9i?
>
> Thanks, Yuel
>
>
>
>
Received on Tue Jul 16 2002 - 22:24:05 CDT