Ora2Pg is a Perl module to export an Oracle database schema to a PostgreSQL compatible schema. ora2pg project 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.What\'s New in This Release: [ read full changelog ]· Fix error on partition export following schema definition.· Add first support to export Oracle user defined types.· Add CTXSYS,XDB,WMSYS,SYSMAN,SQLTXPLAIN,MDSYS,EXFSYS,ORDSYS,DMSYS, OLAPSYS to the sysuser default exclusion list.· PLSQL.pm: Add automatic translation of Oracle raise_application_error and dup_val_on_index to PG RAISE EXCEPTION and UNIQUE_VIOLATION.· Change/fallback to a lower case package name (ora2pg-6.x.tar.gz).· Change default convert type for \'LONG RAW\' to bytea.· Add PG_SCHEMA configuration directive to defined a coma delimited list of schema to use in SET search_path PostgreSQL command.