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: [EMAIL PROTECTED] 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: [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.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] 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: [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).