| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Seems odd to me....(bug?)
Ran into somthing like this when MS Access (Old Microsoft ODBC drivers) was
used to create or copy a table from access to Oracle. It created a table
with lower case letters. The table existed but when SQLPlus is used all SQL
is converted to upper case. I don't know if this is your case but it might
be. I think I had to use Access in query passthrough mode to prevent the
upper case conversion so I could recreate the table properly...long time
ago...and this was on 7.3...vauge memories...
??
-----Original Message-----
Sent: Thursday, October 02, 2003 5:40 PM
To: Multiple recipients of list ORACLE-L
Oracle EE 8.1.7.2
HP-UX 11
Can anyone explain this?
1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL) SQL> / INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL) *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
1* select count(*) from user_tables where table_name='EMPLOYEE_ROLE' SQL> / COUNT(*)
1
SQL> CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES; CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES *
ERROR at line 1:
ORA-00955: name is already used by an existing object
Any ideas?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: ChrisStephens_at_affina.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 Fri Oct 03 2003 - 09:19:25 CDT
 |
 |