Ora2Pg v16.1 released

Paris, France - December 3rd, 2015

**Ora2Pg 16.1 released**

Version 16.1 of Ora2Pg, a free and reliable tool used to migrate an
Oracle database to PostgreSQL, has been officially released and is
publicly available for download.

This release fixes several issues and adds some very useful features:

* Generate automatically a new import_all.sh shell script when using
option --init_project to help automate all import into PostgreSQL. See
sh import_all.sh -? for more information.
* Export Oracle bitmap index as PostgreSQL btree_gin index. This
require the btree_gin extension and PostgreSQL >= 9.4. This is the default.
* Auto set DEFINED_PK to the first column of a table that have a
unique key defined that is a NUMBER. This allow data of any table with a
numeric unique key to be extracted using multiple connexions to Oracle
using -J option. Tables with no numeric unique key will be exported with
a single process.
* Improve BLOB export speed by using hex encoding instead of escape.
This might speed up be BLOB export by 10.
* Allow use of LOB locator to retrieve BLOB and CLOB data to prevent
having to set LONGREADLEN. Now LONGREADLEN is set to 8KB. Old behavior
using LONGREADLEN can still be enabled by setting NO_LOB_LOCATOR to 0,
given for backward compatibility. Default is to use LOB locator.
* Ora2Pg will also auto detect table with BLOB and automatically
decrease DATA_LIMIT to a value lower or equal to 1000. This is to
prevent OOM.
* Improving indexes and constraints creation speed by using the LOAD
action and a file containing SQL orders to perform. It is possible to
dispatch those orders over multiple PostgreSQL connections. To be able
to use this feature, PG_DSN, PG_USER and PG_PWD must be set. Then:
"ora2pg -t LOAD -c config/ora2pg.conf -i schema/tables/INDEXES_table.sql
-j 4" will dispatch indexes creation over 4 simultaneous PostgreSQL
connections. This will considerably accelerate this part of the
migration process with huge data size.
* Domain indexes are now exported as b-tree but commented to let you
know where possible FTS are required.
* Add number of refresh ON COMMIT materialized view in detailed report.
* Allow redefinition of numeric type, ex: NUMBER(3)::bigint to fix
wrong original definition in Oracle.
* Allow export of all schema from an Oracle Instance when SCHEMA
directive is empty and EXPORT_SCHEMA is enabled. All exported objects
will be prefixed with the name of their original Oracle schema or
search_path will be set to that schema name.
* Allow use of COPY FREEZE to export data when COPY_FREEZE is enabled.
This will only works with export to file and when -J or ORACLE_COPIES is
not set or default to 1. It can be used with direct import into
PostgreSQL under the same condition but -j or JOBS must be unset or
default to 1.

Some new configuration directives:

* BITMAP_AS_GIN: enable it to use btree_gin extension to create bitmap
like index with pg >= 9.4. You will need to create the extension by
yourself: "create extension btree_gin;". Default is to create GIN index,
when disabled, a btree index will be�created.
* NO_LOB_LOCATOR: to disable use of LOB locator and extract BLOB
"inline" using a less or more high value in LONGREADLEN.
* BLOB_LIMIT: to force the value of DATA_LIMIT for tables with BLOB.
Default is to automatically set this limit using the following code:
BLOB_LIMIT=DATA_LIMIT; while (BLOB_LIMIT > 1000) BLOB_LIMIT /= 10
* COPY_FREEZE: use it to use COPY FREEZE instead of simple COPY to
speedup import into PostgreSQL.

As usual there is also some bug fixes and Oracle to PostgreSQL conversion
adjustments, for a complete list see:
https://github.com/darold/ora2pg/blob/master/changelog

===== Links & Credits =====

Thanks to all contributors, they are all cited in the changelog file.

Useful Links:

- Website: http://ora2pg.darold.net/
- Download: http://sourceforge.net/projects/ora2pg/
- Development: https://github.com/darold/ora2pg
- Changelog: https://github.com/darold/ora2pg/blob/master/changelog
- Documentation: https://github.com/darold/ora2pg/blob/master/README

--------------

**About Ora2Pg**

Ora2Pg is an easy and reliable tool to migrate from Oracle to
PostgreSQL. It is developed since 2001 and can export most of the
Oracle objects (table, view, materialized view, tablespace, sequence,
indexes, trigger, grant, function, procedure, package, partition,
data, blob, external table, etc.).

Ora2Pg works on any platform and is available under the GPL v3 licence.

Docs, Download & Support at http://ora2pg.darold.net/

--------------

--
Gilles Darold
Consultant PostgreSQL
http://dalibo.com - http://dalibo.org