RE: some thing strange with user_tables vs real table

Or you could just use the rename statement but the concept remains the same.

-----Original Message-----
Sent: Thursday, July 19, 2001 2:55 PM
To: Multiple recipients of list ORACLE-L

Wow, I actually know the answer to this one.

It's a known result of tables from Access, they can end up lower case, mixed case, whatever.

You have to use the quotes around the name, like you did in the second select.

You could get rid of this by:
create table new_tmp_april as select * from 'tmp_april';

So new_tmp_april would be a regular oracle named table.

> -----Original Message-----
> From: Ari, Rama [mailto:Rama.Ari_at_genexservices.com]
> Sent: Thursday, July 19, 2001 4:32 PM
> To: Multiple recipients of list ORACLE-L
> Subject: some thing strange with user_tables vs real table
>
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anderson, Brian
  INET: andersob_at_mail.dartnet.peachnet.edu

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: kimberly.smith_at_gmd.fujitsu.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).