Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help: Can select, truncate but cannot alter and drop a table
I need some help. Here is my question (oracle 8.1.7 on Solaris):
when I alter table A.car or drop table A.car (login as A, owner of car is A in SQL*Plus), following errors shown:
ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist
However, I can truncate table car ("truncate table car", login as A) or "select * from car" in SQL*Plus. Anyone knows why I cannot alter table or drop table car? (Synonym "car" is pointed to A.car) Received on Sat Aug 24 2002 - 03:05:32 CDT