Re: Synonym in trucate table, drop table ...

On Dec 18, 10:46 am, zigzag..._at_yahoo.com wrote:
>  am on Oracle 10.2.0.3 on HP UNIX 11i.
>
> When I execute a statement:
> truncate table t;
>
> where t is a synonym for a table tx
>
> I get error
> ORA-00942: table or view does not exit
>
> However, if I do truncate table tx
> table is deleted.
> synonym however works for insert, select, delete, update etc.
>
> What is rationale for not recognizing synonyms in ceratin statements.
>
> Thanks

I suppose it would be, when you are doing DDL, you want to do it on the proper object. http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7001.htm#sthref7346 says what you can do, but not the rationale. So I guess that means that's just the way it is. Also, consider the differences between public and private synonyms. Maybe it just gets too hinky with the possibilities of dependent objects with several degrees of separation.

Besides that, there are bugs, like this one "fixed in the 10.2.0.5 patchset" metalink Note:603093.1

jg

--
@home.com is bogus.
Spear phishing:  http://ibtimes.com/articles/20081217/personalized-spam-rising-sharply-study-finds.htm