1 select owner, object_name, object_type, status 2 from all_objects 3* where object_name='EMPLOYEE_ROLE' SQL> /
OWNER OBJECT_NAME OBJECT_TYPE STATUS ------------------------------ ------------------------------ ------------------ ------- SBC_GLOBAL EMPLOYEE_ROLE TABLE VALID NET_SBC EMPLOYEE_ROLE SYNONYM VALID.
...when I did the sql in the original message I was connected as sbc_global...so the synonym could not be the problem. ...I've also confirmed that there are no triggers on the table.
I should also mention that this has happened before but since it was ONLY in test, I simply dropped the objects and recreated them. I (without any evidence. .( i know...I know!!)) though it might have have something to do with data dictionary corruption or somehting so I exported the schema and placed it into a database that I have never had problems with. ....that did not solve it.
...I will try Mladen's suggestion next.
chris
-----Original Message-----
something other than a table? Synonym that the inserter only has select on? see what you can find in all_objects or all_tables -----Original Message----- Oracle EE 8.1.7.2 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 COUNT(*) CREATE TABLE EMPLOYEE_ROLE AS SELECT * FROM USER_TABLES * ERROR at line 1: ORA-00955: name is already used by an existing object
-- Fat City Network Services --
858-538-5051 http://www.fatcity.com
|
Title: RE: Seems odd to me....(bug?)
- Seems odd to me....(bug?) Chris Stephens
- RE: Seems odd to me....(bug?) Khedr, Waleed
- Re: Seems odd to me....(bug?) Mark Richard
- Re: Seems odd to me....(bug?) Wolfgang Breitling
- RE: Seems odd to me....(bug?) April Wells
- RE: Seems odd to me....(bug?) Odland, Brad
- Re: Seems odd to me....(bug?) Mladen Gogala
- RE: Seems odd to me....(bug?) Chris Stephens
- RE: Seems odd to me....(bug?) Mladen Gogala
- RE: Seems odd to me....(bug?) Chris Stephens
- RE: Seems odd to me....(bug?) Jamadagni, Rajendra