Re: help: table created not to be found

I do not know what Erwin model is but I think as you see the table names in the enterprise manager are small letters, the Oracle stores the table name as small letters.

However, Oracle is case sensitive in the table name. Even you create or select table in sqlplus or server manager can use both small and capital letters, sqlplus or server manager changes it to capital letter before accessing the table.

One way to solve the problem is to use single quote to quote the table name like:

    select * from 'table_name';

Or you may create synonyms,
or ,in my preference, you should re-import the table with capital letters by first creating the table structure first before importing the data..

Joe

Ming He wrote:

> 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 - 07:56:54 CST