2 Replies Latest reply on Jun 2, 2016 3:45 PM by 708631

    SQL Developer - using different connections ?

    708631

      I recently started working in a different part of our business that uses GreenPlum data warehouse with postgresql.

      They do not have any system for scheduling or jobs.

       

       

      I have setup the Postgresql driver and added the databases to sql developer which work fine. I can connect.

      I installed Oracle XE on my computer.

       

      I need to schedule jobs in my local oracle and have it connect to the postgre databases and pull down data. But I cannot create database links to the postgre databases for some reason.

       

      Does anyone know how to use different connections in a query ? I dont think its allowed but figured I would ask.

       

      thank you