help: table created not to be found

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:44:16 CST