Thank you Ray,
I was checking EDB™ Postgres Advanced Server
and in theory is "completely compatible" with Oracle, this means it has the
same elements and you can almost "import directly from Oracle" and has "all
oracle features", include "plsql compatible", triggers, etc.
Very interesting
Sadly I don't think is less o equal to the price to standard 2 licences,
but I found interesting if some one want to check them.
(video) http://www.enterprisedb.com/compatibility-explained
(features)
http://www.enterprisedb.com/products-services-training/products/postgres-plus-advanced-server?quicktabs_advanceservertab=3#quicktabs-advanceservertab
2016-02-17 15:09 GMT-04:00 Ray Stell <stellr@xxxxxx>:
On 2/17/16 1:53 PM, Juan Carlos Reyes Pacheco wrote:
Is possible to connect through dblink from xe to postgresql tables, in astable permanent oracle db link connection?
I asked a similar question on a postgresql list today. I was directed to
the following links, though it's not a straight line between the two
platforms:
http://docs.oracle.com/cd/E11882_01/gateways.112/e12070/toc.htm
http://docs.oracle.com/cd/E11882_01/owb.112/e10582/loading_ms_data.htm#WBDOD10508
https://www.toadworld.com/platforms/oracle/b/weblog/archive/2015/02/23/connecting-oracle-to-postgresql-using-oracle-gateways
https://community.oracle.com/thread/2312360?tstart=0
--
//www.freelists.org/webpage/oracle-l