Just a note - SQLServer 7 also uses this extremley poor "feature"! The
easiest way to get around it - if you are on 8i - is just to:
alter table <table_name> rename to <TABLE_NAME>;
Mark
-----Original Message-----
Sent: Thursday, July 19, 2001 10:41
To: Multiple recipients of list ORACLE-L
Welcome to the joy of Access. Access will import into Oracle non
sql-compliant objects such as this. If you query
select count(*) from "tmp_april";
you should get a result. To fix this, create your objects in Oracle
first. Then attach the Oracle objects to your Access database. Use a
copy append to select all the records from the Access table into the
Oracle table.
Then go slap your developers and tell them NEVER EXPORT ACCESS OBJECTS
DIRECTLY TO ORACLE!!!!
Rodd Holman
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 7/19/01, 3:32:25 PM, "Ari," Rama <[EMAIL PROTECTED]> wrote
regarding 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
> [EMAIL PROTECTED]
> 610.964.5128
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ari, Rama
> INET: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED] (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: Rodd Holman
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Mark Leith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
