Re: Altering a table using its synonym

In the SQL ref. guide (I checked the 8.1.7 version), under CREATE SYNONYM you'll find a list of SQL-statements in which you can refer to synonyms. ALTER is not among them.

Peter

"Matthieu DEGLIN @partner.auchan.fr>" <mdeglin<remove-me> schreef in bericht 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
>
>
Received on Tue Aug 13 2002 - 03:41:10 CDT