Re: Materialized view from PG to Oracle?

2014-03-12 12:00 GMT+09:00 Roy Anderson <roy.anderson@gmail.com>:
> 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