Is there a way to do what would be an ALTER SYNONYM?

I've got a synonym created that rotates between pointing to two different
tables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This is
so that behind the scenes, I can truncate and reload TABLE_A, and then
swap, etc. so the table "never disappears".)

However, when I want to switch the SYNONYM from pointing to TABLE_A to
pointing to TABLE_B, the only way is to:

drop synonym table_syn;
create synonym table_syn for table_b;

Is there a way to make that instantaneous for the database? If someone
does a select at the exact instant between those two commands, it'll error
out, because the table "won't exist".

-Rick

+--------------------------------------------------------------------------+
| Rick Osterberg [Email Address Removed] |
| Database Applications Specialist FAS Computer Services |
+--------------------------------------------------------------------------+

Oracle LazyDBA home page