but I can truncate table car. Also, I have already specify the owner (i.e.
A.car) in alter and drop table. Any idea?
"Stan" <stan0074_at_yahoo.com> wrote in message
news:3D6817E2.70605_at_yahoo.com...
> 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
>
Received on Sat Aug 24 2002 - 20:19:48 CDT
