Hi,
Using oracle 11.2.0.3 and we have following requirement.
We are re-building a summary table to replace an old one.
Currently reports access a synonymn which in turn accesses old_summary table.
Once built, we would like to change the synonym to point to the new table ideally with no downtime.
Only thing that would be potentially accessing these synonyms when with to chnage table synonym points to is select stattements.
Could of questions.
1) Can you change table synonym points to without dropping and recreating?
2) What happens if have a select statment running and drop sysnonym the recreate. Does it run to completion fact sysnonym existed at start of running?
Thanks