Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help: Can select, truncate but cannot alter and drop a table

Help: Can select, truncate but cannot alter and drop a table

From: David <davidlee_at_diamond.com>
Date: Sat, 24 Aug 2002 16:05:32 +0800
Message-ID: <ak7eh9$41t25@imsp212.netvigator.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US