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

David wrote:

> 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)
>
>
>
>
>

David,

car is a 'synonym' and you can't issue any table related ddl commands against a synonym like alter table, drop table or truncate table...

-- 
hth,
Stan