This shouldn't surprise you. The synonym is just
that: a synonym, i.e. a pointer to the table: it's
not the table itself. You can't truncate a synonym.
The table is only referencable by USER_B using the
name of the schema in which it resides.
Alex Vilner wrote:
>
> I am quite surprised of this behavior, and would like to
> find out if there are ways to work around this, since
> truncate is so much better for cleaning out data from
> temp tables (especially, when they are large) !!!
>
> Sincerely,
>
> Alex Vilner
Received on Wed May 13 1998 - 09:45:44 CDT
