The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Those functions were verified on Oracle 10g, and the module is useful for production work.
Oracle to PostgreSQL migration assessment and schema conversion from an offline dump: reviewable extraction scripts, a SQLite inventory, a deterministic rule engine, and DDL that applies