Re: Altering a table using its synonym

"Matthieu DEGLIN" <mdeglin<remove-me>@partner.auchan.fr> wrote in news:ajafbl$9bq$1_at_reader1.imaginet.fr:

> Hello,
>
> I have a table my_usr.MY_TABLE that as a public Synonym MY_TABLE.
> I try to alter it using:
>
> Alter table MY_TABLE modify col1 date;
> --> ORA-00942: table or view does not exist
>
> This both commands work:
> Alter table my_usr.MY_TABLE modify col1 date;
> select * from MY_TABLE;
>
> Is it the way Oracle work or did I forget something concerning the
> synonym creation ?
>
> Thanks for help.
>
> Matthieu
>
>

That's basically the way it works. You can't alter the table by using the synonym to refer to it. You have to alter the table itself.

-- 
Jason Baugher 
Virtual Adept Professional Consulting Services
1406 Adams St.
Quincy, IL 62301
(217) 221-5406
http://baugher.pike.il.us/virtualadept
jason_at_baugher.pike.il.us