| From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
|---|---|
| To: | Roy Anderson <roy(dot)anderson(at)gmail(dot)com> |
| Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Materialized view from PG to Oracle? |
| Date: | 2014-03-12 13:28:03 |
| Message-ID: | CAB8KJ=jMFS9LpTLYVy0oyX2a95pF_nk5f8pafZOJZ3ZgGo0E8A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2014-03-12 12:00 GMT+09:00 Roy Anderson <roy(dot)anderson(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-03-12 13:53:58 | Re: libpq - lack of support to set the fetch size |
| Previous Message | Sehrope Sarkuni | 2014-03-12 13:18:34 | Re: Cannot insert to 'path' field using EclipseLink |