Comment by craigkerstiens

A few other really handy tools when migrating from Oracle to Postgres:

Orafce - An extension to bundle in Oracle functions -https://github.com/orafce/orafce

OracleFDW - A foreign data wrapper to query directly into Oracle from Postgres - https://github.com/laurenz/oracle_fdw