Re: Seems odd to me....(bug?)

scott> @connect system/manager

system> create table employee_role (a number);

Table created.

system> grant all on employee_role to scott;

Grant succeeded.

system> @connect scott/tiger
Connected.

scott> create synonym employee_role for system.employee_role;

Synonym created.

scott> select * from employee_role;

no rows selected

scott> @connect system/manager
Connected.

system> revoke all on employee_role from scott;

Revoke succeeded.

system> @connect scott/tiger
Connected.

scott> INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL); INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)              *
ERROR at line 1:
ORA-00942: table or view does not exist

scott>

Do a "select * from user_objects where object_name = 'EMPLOYEE_ROLE' " At 04:39 PM 10/2/2003, you wrote:
>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).

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.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).