Copying Data from Oracle to Postgres

We have a daily process that pulls all data out of a number of tables in an Oracle dat开发者_JAVA百科abase 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.

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.