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
or even on 7.X or 8.X if you are logged as the
owner: rename old table to new table
--- Mark Leith [EMAIL PROTECTED] wrote:
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
This is when it will happen... Access usually does the and hence the
problem...
SVCTOOLcreate table test (testnum number);
Table created.
SVCTOOLselect table_name from user_tables;
TABLE_NAME
--
test
SVCTOOLdesc test
ERROR:
ORA-04043: object test does not exist
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
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
Thanks for your info.
Now, I understood Microsoft Access trick.
Thanks,
Rama Ari
Database Administrator
[EMAIL PROTECTED]
610.964.5128
-Original Message-
Sent: Thursday, July 19, 2001 5:21 PM
To: Multiple recipients of list ORACLE-L
you have to double quote the table name and
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