Copying Data from Oracle to Postgres

Question

We have a daily process that pulls all data out of a number of tables in an Oracle database and imports them into a Postgress (EnterpriseDB) database - Version 8.4.

We are currently using a java application to select * from each table, change the keywords (date, timestamp, etc) and then import them into the Postgres Database.

Are there any tools available in Postgres that would provide a more efficient manner of doing this? I should note that there are CLOBs that are being transported over.

Peter Eisentraut · Accepted Answer · 2011-09-02 14:40:28Z

5

There is Ora2Pg, which is intended as a one-time-migration tool, but it might work in your case as well. I think of it as an Oracle-to-PostgreSQL pg_dump.

answered Sep 2, 2011 at 14:40

Peter Eisentraut

37.1k12 gold badges91 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user739866 Over a year ago

Thanks. I will have to check this out and see if it takes care of our needs.

Collectives™ on Stack Overflow

Copying Data from Oracle to Postgres

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related