Sameer Kumar wrote: > I guess I will be exploring more on oracle foreign data wrapper. > > Has anyone tried using oracle_fdw with Oracle RAC? I am wondering how would it handle failovers. I have not tried it, but it should work as follows: - You'll have to use a connect string that is correctly defined for "transparent application failover", see http://docs.oracle.com/cd/E11882_01/network.112/e10836/advcfg.htm#NETAG455 - Failover will happen automatically. - SELECTs should be able to complete without error message. - INSERT, UPDATE and DELETE will fail with an error message and will have to be retried. I did not code oracle_fdw to support TAF for DML statements. Yours, Laurenz Albe
