Re: some thing strange with user

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Sun, 22 Jul 2001 10:07:39 -0700
Message-ID: <F001.00350EC7.20010722084023@fatcity.com>

Rama,

This is an issue with any object that is created via an ODBC connection as ODBC encloses the names in double quotes. Unless the application specifically converts them to uppercase before issuing the DDL, they'll be created with mixed case.

This is most commonly seen when converting tables from MS Access to Oracle. Be advised that this affects the column names too, so they may need to be enclosed in double quotes in order to be accessed. Because of this, I prefer to take the time to convert all table and column names to upper case and Oracle naming conventions BEFORE converting them from Access.

BTW, you can do the same thing manually by enclosing the table or column names in double quotes.

HTH,

Anita
- "Ari, Rama" <Rama.Ari_at_genexservices.com> wrote:
  > 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).

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.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 Sun Jul 22 2001 - 12:07:39 CDT

Re: some thing strange with user_tables vs real table