CODEWITHSUNDEEP
postgresqloracle11genterprisedb
user739866
user739866

Reputation: 881

Copying Data from Oracle to Postgres

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.

Upvotes: 4

Views: 6031

Answers (1)

Peter Eisentraut
Peter Eisentraut

Reputation: 36729

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.

Upvotes: 5

Related Questions