2014-03-12 12:00 GMT+09:00 Roy Anderson <roy.anderson@xxxxxxxxx>: > Good day. We are transitioning over one database to Postgres as a test but > retain an Oracle presence. The PG db in question is (it is currently still > running Oracle) feeds a couple other Oracle dbs via materialized view logs > and materialized views. Is it possible to achieve the same MV functionality > in PG (i.e., have it feed Oracle via MVs)? Not directly. The reverse would be possible at SQL level with the Oracle FDW (see: http://pgxn.org/dist/oracle_fdw/ ) but otherwise you'd need some kind of custom script/cronjob which reads the Postgres materialised view and imports it to Oracle. Regards Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
