Changing tables on a running system

We have an application which runs continuously, processing queries from a table. The application uses the Pro * C interface dynamic SQL feature. The application opens/fetches/closes a cursor once for each query . The application also uses a synonym which points to one of two active Oracle tables.

Simultaneously, we also want to change the synonym after a new table is loaded. Once in a while, though, the synonym gets changed while the application is in the middle of an open/fetch/close,.

Does anyone know how to swap tables that guarantees the applications will continue to operate correctly?

---


----------------------------------------------------------------------

				Don Gillespie	
				U S WEST Advanced Technologies
				deg_at_advtech.uswest.com


----------------------------------------------------------------------