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 existscott>
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: [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).
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: [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).
