Re: Help: tables created not to be found

the table names are all in small letters... They shouldn't or you should use select * from "emp" always. Lowercase are considered to special characters. You should 'tell' Erwin the one way or the other it should use uppercase table names.

Hth,

--
Sybrand Bakker, Oracle DBA
Ming He <hming_at_sungardenergy.com> wrote in message news:85395p$ltn$1_at_news.jump.net...
> Here is my situation. I used Erwin model to forward-engineer my data
schema
> to a oracle 8i database. In oracle enterprise manager, I can see all the
> tables created and the table names are all in small letters.
>
> I then went to sqlplus, and try to do a select statement of a table. To my
> surprise, I got the error message which said that the table was not found.
> (but the table does exist in the oracle database, because enterprise
manager
> lists the object). I then tried capital letter for the table in the select
> statement. I, however, got the same error message.
>
> I then create a new test table. I then select the new table. I have no
> problem in selecting the new table. In enterprise manager, I saw the table
I
> created manually was in capital letters. I guess sqlplus somehow converted
> what I typed to capital letter no matter in what case my statement is.
>
> Could any one please tell me how to solve the problem?
>
> Thanks,
>
> Ming
>
>
Received on Fri Jan 07 2000 - 00:08:48 CST