Re: help: table created not to be found

Are you sure you are using the same schema/instance for both Enterprise Mgr and Sqlplus?

Ming He schrieb:

> 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 Thu Jan 06 2000 - 17:57:03 CST