some thing strange with user_tables vs real table

From: Ari, Rama <Rama.Ari_at_genexservices.com>
Date: Thu, 19 Jul 2001 12:53:21 -0700
Message-ID: <F001.0034F178.20010719123226@fatcity.com>

One of our programmer had imported a table from ACESS database.

When I query user_tables I get following result. SQL> select table_name from user_tables where table_name= 'TMP_APRIL'

no rows selected

SQL> select table_name from user_tables where table_name= 'tmp_april'

TABLE_NAME

---

tmp_april

When I query tmp_april table I get following result. SQL> select count(*) from tmp_april;
select count(*) from tmp_april

                     *

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

SQL> select count(*) from TMP_APRIL;
select count(*) from tmp_april

                     *

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

For some reason, table name has been stored as tmp_april (lower case). When we create table it supposed to store table name with upper case.

Did any one had similar kind of problem?

Thanks in Advance,

Rama Ari
Database Administrator
rama.ari_at_genexservices.com
610.964.5128

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ari, Rama
  INET: Rama.Ari_at_genexservices.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jul 19 2001 - 14:53:21 CDT