ora2pg

Ora2Pg is a Perl module to export an Oracle
database schema to a PostgreSQL compatible schema.
It connects your Oracle database, extracts its
structure, and generates an SQL script that you
can load into your PostgreSQL database. It dumps
the database schema (tables, views, sequences,
indexes, grants) with primary, unique, and foreign
keys into PostgreSQL syntax without editing the
SQL code generated. It also dump Oracle data into
PostgreSQL DB as online process or into a file.
You can choose what columns can be exported for
each table.

Release Notes: This release fixes many issues and adds three new features. Using the REORDERING_COLUMNS directive, you will be able to reorder columns to minimized the footprint on disk so that more rows fit on a data page. The PG_SUPPORTS_MVIEW allow the export of materialized view with native PostgreSQL 9.3 syntax. The USE_TABLESPACE variable can be used to export objects using their original tablespace.

Release Notes: This release fixes several major issues with migration cost assessment, especially with stored procedures with lot of lines or if you have lot of comments in that code. You may want to run your database evaluation again, as the estimated times can be up to three times lower on huge PL/SQL code.