Synonym in trucate table, drop table ...

 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 Received on Thu Dec 18 2008 - 12:46:25 CST