FW: Multiple databases question

 

Here is the situation:

 

I have a bunch of tables in PostgreSQL. Our production db is Oracle running on Unix. I would like to read records from PostgreSQL and insert them into Oracle tables. Is there a simple way, say via PSQL or PL/SQL routine, to do this?

 

Thanks

 

 

---

                      Peter Jagaraj

             Data Warehouse Analyst

Enterprise Technology Services

     Phone:(952) 857-6151   Fax:(952) 238-8711
                                  GMAC- RFC

           peter.jagaraj@xxxxxxxxxxx