Softpedia >Linux >Database >Database APIs >Ora2Pg >  Changelog

Ora2Pg Changelog

What's new in Ora2Pg 14.1

Dec 8, 2014
  • Remove ALLOW_CODE_BREAK, it is no more useful.
  • Change output of SHOW_ENCODING to reflect change to default encoding.
  • Comment ALLOW_PARTITION in default configuration file.
  • Add QUERY and KETTLE export type in configuration file comments.

New in Ora2Pg 12.1 (Jan 29, 2014)

  • Fix example given for the WHERE configuration directive. Thanks to Bob Treumann for the report.
  • Add INDEXES_SUFFIX configuration option to allow append a suffix to indexes names.
  • Replace special charater ^M by \r as they are not supported by git.
  • Fix IF EXISTS in alter table of sub _drop_foreign_keys. Thanks to Francis Corriveau for the patch.
  • Fix isolation level when exporting data. Thanks to Ludovic Penet for the report.
  • Fix regression when ora2pg tries to create foreign keys on tables or to tables that are not selected for export. Thanks to Ludovic Penet.
  • Add information about backslashed comma into directive MODIFY_TYPE into Makefile.PL.
  • Add missing MODIFY_TYPE definition in documentation.
  • Allow backslashed comma into MODIFY_TYPE type redefinition. Example: TABLE1:COL3:decimal(9\,6),TABLE1:COL4:decimal(9\,6). Thanks to Mike Kienenberger for the report
  • Fix missing single cote into create_materialized_view() call. Thanks to Jacky Rigoreau for the patch.
  • Fix some typo in documentation, thanks to Mike Kienenberger for the report.
  • Add a chapter about installing DBD::Oracle into documentation. Thanks to Raghavendra for the patch.
  • Fix case sensitivity on external table name with FDW export type. Thanks to Guillaume Lelarge for the report.
  • Fix export of materialized views when PG_SUPPORTS_MVIEW is disabled. Thanks to Christian Bjornbak for the report.
  • Update copyright.

New in Ora2Pg 12.0 (Oct 23, 2013)

  • This version 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.

New in Ora2Pg 11.4 (May 29, 2013)

  • Fix other major issues in migration cost assessment.
  • Redefine some migration cost values to be more precise.

New in Ora2Pg 11.3 (May 28, 2013)

  • Add full details about PL/SQL evaluation by ora2pg when --estimate_cost or ESTIMATE_COST is enable. This will display cost units per keywords detected in the function/package code.
  • Fix wrong cost unit assessment on PL/SQL code size, this bug generated very high migration cost assessment for functions/packages with lot of lines. Please run your tests again, estimated times can be up to tree time lower on huge code.
  • Remove comments before code evalution.
  • Fix file input parser for PL/SQL packages export when IS or AS was in the next line than the CREATE PACKAGE BODY ...
  • Exclude NOT NULL constraint from the count of CHECK constraints into the TABLE report.
  • Fix decimal precision in table migration assessment cost.
  • Fix typo in changelog.

New in Ora2Pg 11.2 (May 2, 2013)

  • Update doc about Windows multiprocess issues and acknowledgements.
  • Fix Windows OS issues using multiprocessing options by disabling multiprocess support on this plateform. When -J or -j will be used a warning will be displayed and Ora2Pg will simply run single process like in previous 10.x versions. Thanks to Jean Marc Yao Adingra for the report.
  • Fix RAW and LONG RAW export to ByteA. Thanks to Prabhat Tripathi for the report and testing.
  • Fix patch regression on multiple TRUNCATE call for a single table. Thanks to David Greco for the report.
  • Placed calls to DB handle InactiveDestroy outside the forked process to prevent fatal errors on Windows. Thanks to Jean Marc Adingra for the report.
  • Forked running processes are renamed into more readable name like "ora2pg logger" for the progress bar, "ora2pg
  • querying Oracle" when used with -J option and "ora2pg
  • sending to PostgreSQL" to better know what is the current job of the process.
  • Removed the use of /Y flag in Windows install script, this was causing error "dmake: Error code 130, while making install_all". Thanks to Jean-Marc Adingra for the report.
  • Fix direct import to PostgreSQL that was just producing nothing. Thank to David Greco for the patch.
  • Fix ora2pg usage documentation.
  • Add an underscore to CLIENT ENCODING in SHOW_ENCODING output to be the same as the configuration directive.

New in Ora2Pg 11.1 (Apr 8, 2013)

  • Adjust cost assessment for indexes, tables and tables partition.
  • Add comment to report of index partition about local index only.
  • Fix position of TRUNCATE TABLE in output file.
  • Fix export of data from RAW or LONG RAW columns, they was exported as hex string. Now data are converted using utl_raw.cast_to_varchar2() function before being escaped for insert into a bytea. Thanks to Alex Delianis for the report.
  • Fix issue with Oracle TIMESTAMP(0) data export that add a single ending point, ex: "2008-08-09 00:00:00.", this ending character is now removed by format_data_type(). Thanks to Pierre-Marie Petit for the report.
  • Fix typo on MODIFY_STRUCT description.
  • Force DEBUG to off in default configuration file.
  • Change range PARTITION operators in the check conditions, >= and < replaced by > and

New in Ora2Pg 11.0 (Mar 26, 2013)

  • Add documentation about JOBS, ORACLE_COPIES, DEFINED_PK configuration directive and informations about KETTLE export type.
  • Add KETTLE export type to generate XML transformation file definition for Penthatlo Data Integrator (Kettle). Thanks to Marc Cousin for the work. Example of use: ora2pg -c ora2pg.conf -t KETTLE -j 12 -J 4 -o loaddata.sh
  • Fix major bug in export of auto generated named constraint. Thanks to mrojasaquino fot the report.
  • Show number of rows in the top largest tables.
  • Add TOP_MAX description to the documentation.
  • Add the TOP_MAX directive to default configuration file and update documentation. Directive used to control the top N tables to show.
  • Add top N of largest tables in SHOW_TABLE, SHOW_COLUMN and SHOW_REPORT export type.
  • Fix progressbar output when ora2pg is interrupted by ctrl+c.
  • Add JOBS, ORACLE_COPIES and DEFINED_PK directives to configuration file. JOBS replacing THREAD_COUNT but backward compatibility is preserved.
  • Add 3 new command line options, -j | --jobs and -J | --copies, used to set the number of connection to PostgreSQL and Oracle for parallel processing. The third, -L | --limit is used to change DATA_LIMIT at command line.
  • Add multiprocess support on data export. With the help of Thomas Ogrisegg.
  • Add more schema in SYSUSERS that should not be exported.
  • Add full detailed information about SYNONYM in SHOW_REPORT.
  • Add MODIFY_TYPE configuration directive to allow some table/column type to be changed on PostgreSQL side during the export.
  • Fix objects type count in progressbar of SHOW_REPORT.
  • Restrict table and index in SHOW_REPORT to the tables defined in ALLOW and EXCLUDE directives.
  • Show total number of rows in SHOW_TABLE and SHOW_REPORT output.
  • Add top 10 of tables sorted by number of rows in SHOW_TABLE and SHOW_REPORT output.
  • Fix typo in SYNONYM objects.
  • Add report of top ten tables ordered y number of rows.
  • Rewrite most of the Oracle schema storage information extraction for speed improvement.
  • Use Hash to store column informations.
  • Fix %unique_keys declaration in _table() method.
  • Remove call to _table_info() from SHOW_REPORT code as those informations are already loaded with the _table() method.
  • Fix missing column definition on TABLE export.
  • Add progress bar during output generation following export type.
  • Add STOP_ON_ERROR configuration directive to enable/disable the call to ON_ERROR_STOP into generated SQL scripts. Thanks to Ludovic Penet for the feature request.
  • Huge speed improvement on columns informations retrieving.
  • Fix progress bar to keep the total number of tables related to the ALLOW or EXCLUDE configuration directives. Thanks to Ludovic Penet for the report.
  • Change return type of function _table_info(), it now returns data instead of the database handle.
  • Improve speed on indexes and constraints extraction for database with huge number of tables.
  • Improve performance to retrieve columns information and comments.
  • Remove report of column details during export in debug mode, use SHOW_COLUMN instead.
  • Remove call to upper() in objects owner condition to improve performance with database with huge number of objects.
  • Add a fix to not export foreign key for exclude tables. Thanks to Ludovic Penet for the report.
  • Fix Windows install issue with copying ora2pg.conf.dist. Thanks to Dominique FOURDRINOY for the report.
  • Increase the cost of Oracle function not converted to PG automatically.

New in Ora2Pg 10.1 (Jan 16, 2013)

  • Fix global where clause that should not be overwritten. Thanks to Dan Harbin for the patch.
  • Fix bug/typo in boolean replacement, where a colon was used instead of a single quote. Thanks to Alex Delianis for the patch.
  • Update copyright.
  • Add detection of additional Oracle functions for better migration cost assessment.
  • Update documentation.
  • Force report detail in lowercase.
  • Added information about the migration cost value to the reports.
  • Add --dump_as_html command line option and DUMP_AS_HTML configuration directive.
  • Allow migration report to be generated as HTML.
  • Separate report generation code from data collection code

New in Ora2Pg 10.0 (Dec 19, 2012)

  • Update documentation about ora2pg usage and new feature.
  • Fix quote escaping on table comments. Thanks to Sebastian Fischer.
  • Fix some other issues with 8i databases, added database version auto-detection to avoid printinf warning. Thanks to Sebastian Fischer for the help.
  • Allow null value in BFILE to the oar2pg_get_bfilename().
  • Update documentation about BFILE export.
  • Add drop function ora2pg_get_bfilename() when necessary.
  • Add support to BFILE external path export by creating a function ora2pg_get_bfilename( p_bfile IN BFILE ) to retrieve path from BFILE. BFILE will be exported as text field with the full path to the file as value. Note that this is the first time that Ora2Pg need write access to the Oracle database, if you do not have BFILE or you have set the corresponding PostgreSQL type asd bytea (the default) the function will not be created.
  • Fix a performance issue when extracting BLOB with a LongReadLen upper than 1MB.
  • Fix priviledge on schema created from Oracle package body. Thanks to Dominique Legendre for the report.
  • Add object type in comment before priviledge extraction.
  • Order output of grant to groups grants by object types. This is useful to quickly disable some SQL orders corresponding of not already loaded objects. Thanks to Dominique Legendre for the feature request.
  • Fix progress bar output.
  • Fix priviledge on sequence, tablespace and schema.
  • Fix backward compatibility with Oracle 8i, remove query with JOIN. Thanks to Sebastian Fischer for the report.
  • Fix backward compatibility with Oracle 8i on priviledge extraction. Thanks to Sebastian Fischer for the report.
  • Fix backward compatibility with Oracle 8i on index extraction. Thanks to Sebastian Fischer for the report.
  • Add more precision in cost estimation.
  • Add somme other PL/SQL uncovered code detection.
  • Add more debug information during data extraction.
  • Removed progress bar when debug is enabled.
  • Add report and estimate cost about CHECK constraint and function based indexes.
  • Update documentation about new export directives SHOW_REPORT and ESTIMATE_COST.
  • Add --estimate_cost and --cost_unit_value command line options.
  • Add ESTIMATE_COST and COST_UNIT_VALUE to default configuration file.
  • Rewritte and extend support to ROWNUM replacement.
  • Remove incompatible grants between Oracle and the PortgreSQL export, especially on views.
  • Limit GRANT export to VALID object. Activate EXPORT_INVALID to enable grants export on all object.
  • Add export of VALID only views. To export all with INVALID ones you must activate the EXPORT_INVALID directive. Thanks to Dominique Legendre for the feature request.
  • Fix issue in substr() pl/sql replacement, thanks to Dominique Legendre for the report, plus add other code replacements in pl/sql.
  • Fix issue with function name not on the same line as the create statement
  • was affecting file input only.
  • Add report of number of JOB object in the database (SHOW_REPORT).
  • Add PL/SQL replacement of various form of EXEC function call.
  • Remove creation of password with users that are not requiring password. Thanks to Dominique Legendre for the feature request.
  • A sql type and a precision can now be used in REPLACE_AS_BOOLEAN to replace all filed with that type as a boolean, example: NUMBER:1 will replace all field of type NUMBER(1) as a boolean.
  • Fix grants on partition export, will now used all_ and user_ tables.
  • Fix removing of newline in the DECLARE clause. Thanks to Dominique Legendre for the report.
  • PostgreSQL client_encoding is now forced to UTF8 when BINMODE is set to utf8. Thanks to Dominique Legendre for the report.
  • Replace DISABLE TRIGGER ALL by DISABLE TRIGGER USER following the value if USER_GRANTS to avoid permission denied on constraint trigger when data are load under a non PG superuser. Thanks to Dominique Legendre for the report.
  • Rename DISABLE_TABLE_TRIGGERS to DISABLE_TRIGGERS and set default value to 0. Other values are USER or ALL following the connected user.
  • Fix missing newline after comment in PL/SQL code. Thanks to Dominique Legendre for the report.
  • Fix report message on external table export.
  • The export TYPE have been entirely rewritten to only export supported user defined types. Exported are: Nested Tables, Object type, Type in herited and Subtype, Varrays. Associative Arrays, Type Body and type with member method are not supported.
  • When FILE_PER_INDEX is enable, SQL order to move indexes in their respective tablespace will be written into a dedicated file prefixed by TBSP_INDEXES_.
  • Fix location on external table export. Thanks to Thomas Reiss for the help.
  • PG_SUPPORTS_INSTEADOF is now activated by default, that mean that migration should be done on PG >= 9.1.
  • Remove obsolete --xtable commande line option, should be replaced by --allow, backward compatibility is preserved.
  • Add EXTERNAL_TO_FDW configuration directive, disable by default, to export all Oracle external tables as file_fdw foreign tables.
  • Fix an other case where user defined type were not exported with an ending semi-colon. Thank to Dominique Legrendre for the report.
  • Fix export of user defined type with extra ");" at end of the type definition and remove system types from export. Thanks to Dominique Legendre for the report.
  • Add PLSQL replacemement of currval. Thanks to Thomas Reiss for the patch.
  • Add PLSQL replacement of PIPELINED and PIPE ROW by SETOF and RETURN NEXT.
  • Add rewrite of Oracle DETERMINISTIC function into PostgreSQL IMMUTABLE function.
  • Fix copy during install on MacOSx and add /Y option to windows install copy to force overwrite existing files. Thanks to Dennis Spaag for the report.
  • Fix issue exporting rows with perl ARRAYS ref. Thanks to Sorin Gheorghiu for the report.
  • Add report of number of database link in SHOW_REPORT output.
  • Fix major bug on export of NUMBER with precision, they was all exported as bigint. Thanks to Dominique Legendre for the report.
  • Add progress bar during SHOW_REPORT export.
  • Add detailed report about index in SHOW_REPORT output.
  • Fix data export when schema was given in lower case. Thanks to Dominique Legendre for the report.
  • Add SHOW_REPORT export type to display a full summary of the Oracle database content.
  • PLPGSQL: add the name keyword to XMLELEMENT call. Thanks to Thomas Reiss for the hint.
  • Add SHOW_VERSION export type to display the version of Oracle.
  • Add COLLATION to the keyword list. Thanks to Dominique Legendre for the report
  • Change documentation to add more detail on exporting Oracle views as PostgreSQL tables based on the new VIEW_AS_TABLE directive.
  • Add -a | --allow option and --view_as_table to ora2pg script.
  • Add VIEW_AS_TABLE configuration option to allow export of view as table and permit the additional use of the ALLOW or/and EXCLUDE directive. Thanks to Dominique Legendre for the feature request.
  • Removed conflict with transaction when DEFER_FKEY was enabled and allow DEFER_FKEY and DROP_FKEY to be enabled both. Before, only DEFER_FKEY was used in this case, now both are used and of course DEFER_FKEY is wasted. Thanks to Dominique Legendre for the report.
  • Directives ALLOW and EXCLUDE are now usable with all kind of object following the export type.
  • Rename TABLES directive as ALLOW to be less confusing, backward compatibility is preserved.
  • Thanks to Dominique Legendre for the feature request.
  • Remove auto ordering of table export following the foreign keys to fix an infinite loop. Thanks to Siva Janamanchi for the report.
  • Rewrite the view as table export to reuse the same code as table export, old code was resulting in issues with disable triggers and deferring constraints.
  • Remove alter session to set NLS_NCHAR that was returning error on some installation. Thanks to Dominique Legendre for the report.
  • Fix replacement of IS SELECT wrongly replaced by IS PERFORM in some case. Thanks to Dominique Legendre fot the report.

New in Ora2Pg 9.3 (Oct 8, 2012)

  • Add auto detection of Oracle character set and the corresponding PostgreSQL client encoding to use. NLS_LANG and CLIENT_ENCODING configuration directives can be leaved commented, Ora2Pg will set their values automatically.
  • Add PL/SQL replacement of CURSOR IS SELECT by CURSOR FOR SELECT and IS REF CURSOR by REFCURSOR. Thanks to Dominique Legendre for the report.
  • Fix missing set client_encoding orders into fonction or procedure export file. Thanks to Dominique Legendre for the report.
  • Fix not working SKIP configuration directive. Thanks to Siva Janamanchi for the report.
  • Add configuration directive NULL_EQUAL_EMPTY to disable the IS NULL and IS NOT NULL replacement into PL/SQL code. Enabled by default. Thanks to Dominique Legendre for the feature request.
  • Remove exclusion of object names with the dollar sign. Thanks to Konrad Beiske for the suggestion.
  • Fix timestamp with time zone when microsecond is enabled. Thanks to Siva Janamanchi for the report.
  • Fix extra semi-column when PKEY_IN_CREATE is enabled. Thanks to Siva Janamanchi for the report.
  • Update configuration about boolean replacement. - Allow any column type replacement as a boolean in PostgreSQL, values will be converted as well. Thanks to Konrad Beiske for the feature request.
  • Add REPLACE_AS_BOOLEAN and BOOLEAN_VALUES configuration directives to allow type replacement with a boolean. Thanks to Konrad Beiske for the feature request.
  • Add new configuration directive PKEY_IN_CREATE to add primary keys definition in CREATE TABLE statement instead of creating them after with an ALTER TABLE statement. For Greenplum database, primary key must be created with the CREATE TABLE statement so you may want to enable this configuration directive. Thanks to Siva Janamanchi for the feature request.
  • Add new configuration directive USE_RESERVED_WORDS to force Ora2Pg to auto-detect PostgreSQL reserved words in Oracle object's names and automatically double quote them. Thanks to Siva Janamanchi for the feature request.
  • SHOW_TABLE and SHOW_COLUMN will now display a warning when Oracle object's name is a PG reserved words. Those names will need to be renamed or double-quoted (see USE_RESERVED_WORDS).
  • Add TIMESTAMP WITH LOCAL TIME ZONE Oracle type conversion to timestamp and force timestamp with time zone format to use TZH:TZM. Thanks to Siva Janamanchi for the report.
  • Fix table and column replacement issues introduced with path that removed double-quote when PRESERVE_CASE is disabled. Thanks to Steve DeLong for the report.
  • PLPGSQL convertion: Fix SELECT replacement with PERFORM in VIEW declaration. Thanks to Thierry Capitaine for the report.
  • Add display Ora2Pg type conversion map between Oracle originals types and PostgreSQL's types when using export type SHOW_COLUMN. Thanks to Thierry Capitaine for the feature request.
  • Reorder command line options in ora2pg script usage and documentation.
  • Add call to quote_ident() and quote_literal() into materialised functions to secure parameters.
  • Fix major issue in pl/sql to pl/pgsql conversion with multiple package declaration in the same code record. Thanks to Marc Cousin for the report.
  • Add data type TIMESTAMP WITH TIME ZONE. Thanks to Siva Janamanchi for the report.
  • Add new export type: MVIEW to allow export of all materialised views as snapshot materialised view (fully reload of the view).
  • Add -e | --exclude option to Perl script ora2pg to exclude some given objects from the export. It will override any value of the EXCLUDE directive. The value is a coma separated list of object name or regex.
  • Update domumentation about the EXCLUDE directive change.
  • Allow exclusion from export of functions, procedures and functions in package by specifying a list of name or regex in EXCLUDE directive. Thanks to Keith Fiske from Omniti for the feature request.

New in Ora2Pg 9.2 (Sep 6, 2012)

  • In plpgsql conversion, SELECT without INTO becomes PERFORM.
  • In plpgsql conversion, EXECUTE IMMEDIATE replaced by EXECUTE.
  • Fix DATA_TYPE value in configuration file.
  • Fix case sensitivity on data export using COPY mode.
  • Directive XML_PRETTY is now disabled by default as it is better to use getClobVal() to get the XML data out of an xmltype column.
  • Add documentation about regex usage int EXCLUDE and TABLES directives.
  • Remove all double-quote around object name when CASE_SENSITIVY is disabled. Thanks to Dominique Legendre for the suggestion.
  • Rename CASE_SENSITIVE by PRESERVE_CASE to be less confusing, backward compatibility preserved. Thanks to Dominique Legendre for the request.
  • Add support to user defined type data export. Before it will simply export an array reference ARRAY(0xa555fb8), now the array is explored and inserted as ROW(col1,col2,...). Thanks to Mathieu Wingel for the feature request.
  • Fix bug in direct data import in postgresql with COPY: pg_putcopydata can only be called directly after issuing a COPY FROM command. Thanks to Steve Delong for the report.
  • Add warning at any debug level before abort when a data file already exist during data export.
  • Fix issue with oracle sensitivity when exporting data.
  • Fix search_path on package export, indexed and constraints files on TABLE export.
  • Remove obsolete ORA_SENSITIVE configuration directive, thanks to Dominique Legendre it is no more used.
  • Force automatic conversion of PL/SQL when entry is an input file.
  • Fix errors in main file for package loader with FILE_PER_FUNCTION enabled.
  • Fix case where package body where not exported.
  • Add missing EXPORT_INVALID directive into default configuration file.
  • Fix replacement of END followed by the name of the function, the semi- colon was removed.
  • Fix case sensitivity issue in INDEX creation.
  • Fix case sensitivity issue in CHECK constraint and a typo in a progress bar variable.
  • Replace old DATA export type by INSERT in configuration file.
  • Fix case sensitivity issue in ALTER TABLE ... ADD CONSTRAINT. Thanks to David Greco for the report.
  • Add set client_encoding before table output to handle character encoding into comments and possibly objects names.
  • Fix some case sensitivity issue with schema name. Thanks to Dominique Legendre for the report.
  • Do not display warning message about direct import if no connection to a PostgreSQL database is defined.
  • Allow multiple export type to be specified into the ora2pg -t command line option.
  • Dump progress bar to stderr instead of stdout to separate logs.
  • Add new -q | --quiet option to perl script ora2pg to disable progress bar.

New in Ora2Pg 9.1 (Aug 20, 2012)

  • Add progress bar to show data export progression.
  • Add -q | --quiet option to ora2pg perl script to disable progress bar.
  • Change documention about tnsnames.ora to mark it is not necessary.
  • Add progress bar during data export, per table and globaly.
  • Replace export type DATA by INSERT to mark the difference with COPY and avoid confusion. Documentation is updated and full backward compatibility preserved.
  • Improve Oracle case sensitivity detection on column and update documentation about ORA_SENSITIVE directive.
  • Direct import for COPY statement now used DBD::Pg and pg_putcopydata() instead of a pipe to psql command.
  • Fix case sentitivity issue on disabling/enabling all triggers.
  • Add autodetection of case sensitivity with column name.
  • Move trunc() to data_truc() convertion into the ALLOW_CODE_BREAK part.
  • Update comment about FILE_PER_FUNCTION in configuration file.
  • Fix NOT NULL constraint add twice, the first time in the column definition and the second time in an ALTER TABLE ... ADD CONSTRAINT ... CHECK ( ... NOT NULL). Reported by Dominique Legendre.
  • Add support to direct CALL of stored procedures in trigger definition. Reported by Dominique Legendre.
  • Remove index creation on primary and unique key autogenerated by PostgreSQL.
  • Fix PL/SQL to PLPGSQL automatic convertion on index when exporting data with DROP_INDEX activated.
  • Fix DROP_INDEX to only delete indexes that will be created at end.
  • Fix search path when exporting data with EXPORT_SCHEMA disabled
  • Add missing documentation about the LOGFILE directive
  • Fix case sensitivity on sequence export. They will now always be insensitive as in PostgreSQL its called is converted between quotes: nextval('seq_name'). Reported by Dominique Legendre.
  • Limit export of primary and unique key if KEEP_PKEY_NAMES is enabled to those who are not autogenerated by Oracle. Reported by Dominique Legendre.
  • Trigger export is now limited to those belonging to table that are not excluded from the export (see TABLES and EXCLUDE directives). Reported by Dominique Legendre
  • Fix case sensitivity on trigger export.
  • Fix data export failure in table with column name with accent. Reported by Dominique Legendre.
  • Fix set client_encoding syntax. Reported by Dominique Legendre.
  • Add automatic try with oracle sensitivity when an error occurs during retreving table information. This additionaly also fixes an error when table has accent on his name.
  • Fix replacement of user defined data type with directive DATA_TYPE. Reported by Dominique Legendre.
  • Fix function or procedure detection with external input file. Reported by Arul Shaji.
  • Update documentation about Windows installation and ActiveState Perl distribution. Thanks to Stephan Hilb for the report.
  • Fix date format issue by forcing NLS_DATE_FORMAT to format: YYYY-MM-DD HH24:MI:SS. Thanks to Stephan Hilb for the report.
  • Remove obsolete pod documentation in Ora2Pg.pm.
  • Add new configuration directive CREATE_SCHEMA to disable the sql command of schema creation at top of the output file during TABLE export type. Patch by David Greco.
  • Added converting INSERTING/UPDATING/DELETING to PG_OP='INSERT|UPDATE|DELETE'. Patch by David Greco.
  • Fix parsing leading ':' on triggers, as they generally have :NEW and :OLD to denote the new and old recordsets. Patch by David Greco
  • Add new PG_INTEGER_TYPE configuration directive activated by default, to limit conversion into postgresql integer or bigint of Oracle number without scale
  • NUMBER(p), PG_NUMERIC_TYPE is now reserved to convert NUMBER(p,s). Patch by David Greco.
  • Limit numeric with precision = 10 will be converted to bigint to handle integer above 2147483647. Patch by David Greco.
  • Add plsql to plpgsql automatic conversion on check constraints. Patch by David Greco.
  • Add plpgsql replacement, patch by David Greco: REGEX_LIKE( string, pattern ) => string ~ pattern.
  • Update documentation about NOESCAPE and STANDARD_CONFORMING_STRING
  • Change place of the ENABLE_MICROSECOND into the documentation.
  • Fix forgot to add documentation about encryption with Oracle server.
  • Add missing DISABLE_COMMENT configuraton directive in default configuration file and update documentation.

New in Ora2Pg 9.0 (Jul 16, 2012)

  • Remove call to obsolete BINDIR and MANDIR variables into packaging scripts to reflect the changes in Makefile.PL.
  • Update documentation about installation of Ora2Pg under Windows.
  • Automatically set LONGREADLEN to ORA_PIECE_SIZE length if the last one is larger, for CLOB export.
  • Change Makefile.PL and source tree to fully support installation under Windows OSes.
  • Change double quote by single in Makefile.PL perl replacement call.
  • Replace double quote by single one in $CONFIG_FILE default setting to simplify automatic replacement at install.
  • Fix CLOB export that was limited to 64Kb even with LONGREADLEN defined to an upper value. Patch use the ora_piece_size DBD::Oracle prepare attribute. Patch by Mohamed Gargouri. See here for more detail: http://search.cpan.org/~pythian/DBD-Oracle-1.46/lib/DBD/Oracle.pm#Piecewise_Fetch_with_Polling
  • Add a note into documentation about encrypted communication between Ora2Pg and Oracle. Note by Jenny Palomino.
  • Change documentation to reflect change to the format of the Oracle timestamp with millisecond. This format is now enabled by default in configuration file.
  • Fix bug with LONGREADLEN and LONGTRUNCOK when exporting LOB that was not applied even after change into the configuration file. Reported by Mohamed Gargouri
  • Fix microsecond format FF3 not compatible with Oracle 8i. Set to FF.
  • Add a warning to stderr when a table export need that ORA_SENSITIVE be enabled.
  • Fix case where Oracle indexes with same name as a constraint was not exportedRodrigo
  • The following are old patches that was not applied to v8.10 and the git repository:
  • Fix creation of bad constraint for each indexes.
  • Add DISABLE_COMMENT configuration directive to remove comments from TABLE export type. Comments are exported by default.
  • Fix a bug in removing function name repetion at end
  • Add PL/SQL to PLGPSQL replacement of the to_number function
  • Fix PL/SQL to PLGPSQL replacement of substr into substring
  • Add replacement of specials IEEE 754 values BINARY_(FLOAT|DOUBLE)_NAN and BINARY_(FLOAT|DOUBLE)_INFINITY by NaN and Infinity on PLPGSQL conversion and on data exportThanks to Daniel Lyons.
  • Fix return type of function with just OUT or INOUT params. Thanks to Krasi Zlatev for the patch.
  • Add schema name on functions or procedures export when EXPORT_SCHEMA is activated. Thanks to Krasi Zlatev for the patch.
  • Fix case sensitivity issue with schema on partition export.
  • Fix case sensitivity issue with --xtable option.
  • Fix issues with case sensitivity on the schema owner set into the SCHEMA configuration directive.
  • Add default search_path on schema for contraints, index and data export when EXPORT_SCHEMA is activated.
  • Fix case sensitivity issue in search_path.
  • Force Oracle datetime format to be YYYY-MM-DD HH24:MI:SS.FF in client session to prevent other defined output format. Thanks to Aaron Culich for the patch.
  • Add export/import of table and column comment. Thanks to Krasi Zlatev for the patch.
  • UPGRADE: all files have changed, you have to reinstall all. Please report any issue.

New in Ora2Pg 8.13 (Jun 27, 2012)

  • Fix broken export with missing single quote in Oracle timestamp export formating with to_char(timestampcolumn, YYYY-MM-DD HH24:mi:ss). Thanks to Steve Delong for the report.

New in Ora2Pg 8.12 (Jun 23, 2012)

  • Add new configuration directive ENABLE_MICROSECOND to allow timestamp to be exported with millisecond precision.
  • Thanks to Patrick King for the feature request.
  • Fix multiple quote on foreign keys column names. Thanks to Vitaliy for the report.
  • Add new export type FDW to allow table export as foreign table for oracle_fdw. Thanks to David Fetter for
  • the feature request.
  • Fix typo in LongTruncOk variable name. Thanks to Magnus Hagander for the patch.
  • Add XML_PRETTY configuration directive to replace getStringVal() by getClobVal() when extracting XML data.
  • Thanks to Magnus Hagander for the patch.
  • Fix case sensitivity issue in ALTER TABLE and TRUNCATE statement. Thanks to Magnus Hagander for the patch.

New in Ora2Pg 8.11 (May 1, 2012)

  • Fix an error when running ora2pg directly against PG, index and constraints are created against PG instead of being written to the output file. Thanks to David Greco for the report.
  • Ora2Pg will now output a warning message when direct import to PG is set with other import type than COPY and DATA.
  • Fix NUL character removing on LOB to bytea export. Thanks to info31 on PostgresqlFr for the report.

New in Ora2Pg 8.9 (Nov 9, 2011)

  • Fix double quote into file name of package function export when case sensitivity is preserved.
  • Add support to XMLType data extraction. Thanks to Aaron Culich for the report. Before this release, xml data was exported as a Perl array reference.
  • Fix bug during foreign key export when foreign keys have different owners. Thanks to Krasi Zlatev for the patch.
  • Add support to plpgsql conversion during index extraction as many index use some Oracle function on their declaration. Thanks to Sriram Chandrasekaran fot the feature request.
  • PLSQL: Add replacement of Oracle subtr() by PostgreSQL substring(). Thanks to Sriram Chandrasekaran for the feature request.
  • PLSQL: Add replacement of Oracle decode() by PostgreSQL CASE/THEN/ELSE. Thanks to Sriram Chandrasekaran for the feature request. Note that this two replacements could break the code if there's complex subqueries inside their declaration. This is why you can enable it by setting ALLOW_CODE_BREAK to 1 (new). In later release this directive will be enable by default.
  • Add output ordering on some object name so that results between two runs can be compared. Thanks to Henk Enting for the patch.
  • Fix misshandling of all cases of RAISE_APPLICATION_ERROR rewrite into RAISE EXCEPTION concatenations. Thanks to Krasi Zlatev for the report.

New in Ora2Pg 8.8 (Oct 14, 2011)

  • Before that release when you upgraded Ora2Pg using Makefile, the old ora2pg.conf was renamed as ora2pg.old. This can lead to lost previous configuration, the old ora2pg.conf is now untouched and the new one is installed as ora2pg.conf.new.
  • Renamed ora2pg.pl into ora2pg_pl in the package before installation to avoid the copy of the perl script into the site Perl install dir. It is still installed as ora2pg in /usr/local/bin by default.
  • Fix errors that appeared to be due to no quoting on the field names when ORA_SENSITIVE is enabled. Thank to Sam Nelson for the patch.
  • Limit case sensitivity on check constraints to column names only, before that if there was a value between double quote into the check constraint, it was wrongly changed to lower case.
  • Fix broken case sensitivity at data export when disabling/enabling triggers and truncating tables with copy or insert statement.
  • Change Ora2Pg version in packaging files that was still in 8.5.

New in Ora2Pg 8.7 (Sep 8, 2011)

  • The escape_bytea() function has been rewritten using a prebuild array to gain twice of performances. Thanks to Marc Cousin from Dalibo for the patch.
  • Improve speed of bulkload data by disabling autocommit by issuing a BEGIN at the start and COMMIT at the end.
  • Add multi-threading support. It is only used to do the escaping to convert LOBs to byteas, as it is very cpu hungry.
  • There's a lot of CPU-waste here. The threads number is controled by a new configuration directive: THREAD_COUNT.
  • Putting 6 threads will only triple your throughput, if your machine has enough cores. If zero (default value), do not use
  • threads, do not waste CPU, but be slower with bytea.
  • Performance seems to peak at 5 threads, if you have enough cores, and triples throughput on tables having LOB. Another
  • important thing: because of the way threading works in perl, threads consume a lot of memory. Put a low (5000 for
  • instance) DATA_LIMIT if you activate threading. Many thanks to Marc Cousin for this great patch.
  • Fix standard_conforming_string usage on export as INSERT statement.
  • Fix an issue with importing Oracle NULL character (\0 or char(0)) with bytea and character data with UTF8 encoding.
  • Now whatever is the data type or the encoding, this character is simply removed to prevent the well known
  • 'ERROR: invalid byte sequence for encoding "UTF8": 0x00.'. Thanks to Jean-Paul Argudo from Dalibo for the report.
  • Fix an incorrect syntax for "for each statement" triggers. Thanks to Henk Enting for the report.
  • Add comment at end of line to signal on which cursor the replacement on " EXIT WHEN (...)%NOTFOUND " is done. This will
  • return something like "IF NOT FOUND THEN EXIT; END IF; -- apply on $1". Thanks to jehan Guillaume De Rorthais from
  • Dalibo for the report this help a lot during Pl/Pgsql code review.
  • Fix table/column name replacement on constraint creation and dropping when REPLACE_TABLES/REPLACE_COLS is set
  • during DATA/COPY export.
  • Fix table/column name replacement on indexes creation and dropping when REPLACE_TABLES/REPLACE_COLS is set
  • during DATA/COPY export.
  • Remove unused table name parameter in _drop_indexes() function.
  • Add support to REPLACE_TABLES/REPLACE_COLS during schema export. Before this release those replacements were
  • only applied to DATA or COPY export. You can now use it in schema export, it will replace table and/or column names in the
  • TABLE/INDEX/CONSTRAINT schema export. MODIFY_STRUCT is still limited to DATA or COPY export as it have no sense
  • outside this export. Unfortunately those replacements can not be done easilly in other export type like TRIGGER, FUNCTION,
  • etc. so you must still edit this code by hand.
  • Use the bundled Perl Config module to detect if Perl is compiled with useithread. This mean that the old local defined
  • %Config hash has been replaced by �onfig.
  • SKIP indices is now obsolete and must be replaced with SKIP indexes. backward compatibility is preserved.
  • The file generated when FILE_PER_INDEX is activated has been renamed into INDEXES_... instead of INDICES_...
  • Add a warning on tablespace export when Oracle user is not a dba.
  • Fix fatal error when dumping to one file per function with double directory output.
  • Fix double print of FATAL messages and dirty database disconnect on fatal errors.
  • Add setting of client_encoding into each export type as defined in the configuration file.

New in Ora2Pg 8.5 (Jul 3, 2011)

  • When FILE_PER_FUNCTION is activated and export type is PACKAGE, Ora2Pg will now save all functions/procedures of a package body into a directory named as the package name and into different files. This will allow to load each function separatly or load them all with the OUTPUT SQL script generated by Ora2Pg.
  • Fix Oracle package body parsing failure when a procedure is declared inside an other.
  • Add new configuration options FILE_PER_CONSTRAINT and FILE_PER_INDEX to generate three files during the schema extraction. One for the 'CREATE TABLE' statements, one for the constraints (primary keys, foreign keys, etc.) and the last one for indices. Thanks to Daniel Scott for the feature request.
  • Allow to process PL/SQL Oracle code from file instead of a database to apply Ora2Pg code conversion. Thank to Mindy Markowitz for the feature request. See -i or --input_file command line option to ora2pg perl script or INPUT_FILE new configuration option.
  • Add new configuration directive STANDARD_CONFORMING_STRINGS that is used only during DATA export type to build INSERT statements. This should avoid 'WARNING: nonstandard use of \\ in a string literal'. Please check that this behavior is backward compatible with your PostgreSQL usage as this is the default now

New in Ora2Pg 8.4 (Jun 8, 2011)

  • Moves Ora2Pg to SourceForge.net.
  • Fix an issue on setting owner in "ALTER SEQUENCE ... SET OWNER TO". Thanks to Herve Girres for the report.
  • Bugfix on lower case convertion for check constraints extraction. Thanks to Alexander Korotkov for the patch.

New in Ora2Pg 8.2 (May 2, 2011)

  • PLSQL: automatic replacement of EXIT WHEN cursor%NOTFOUND; by Pg synthax: IF NOT FOUND THEN EXIT; END IF;. Works with additionals condition too.
  • PSQL: Automatic replacement of SQL%NOTFOUND by NOT FOUND.
  • PLSQL: Add detection of TOO_MANY_ROW to NO_DATA_FOUND to add STRICT.
  • Completely rewrite the parsing of Oracle package body to handle all cases and especially prodedure declared into an other procedure. Those procedure are renamed INTERNAL_FUNCTION and must be rewritten.
  • Fix type usage of ora2pg Perl script.
  • Add a new directive FORCE_OWNER. By default the owner of the database objects is the one you're using to connect to PostgreSQL. If you use an other user (postgres for exemple) you can force Ora2Pg to set the object owner to be the one used in the
  • Oracle database by setting the directive to 1, or to a completely different username by setting the directive value to that username.Thanks to Herve Girres from Meteo France for the suggestion and patch.
  • Add --forceowner or -f command line option to ora2pg program.
  • Add SHOW_ENCODING extract type to return the Oracle session encoding. For example: NLS_LANG AMERICAN_AMERICA.AL32UTF8
  • Remove SYS_EXTRACT_UTC from index creation as Pg always stores them in UTC. Thanks to Daniel Scott for the patch.
  • In PLSQL code SYS_EXTRACT_UTC is replaced by the Pg syntaxe: field AT TIME ZONE 'UTC'.
  • Fix a pending problem with "Wide character in print at" on COPY mode. Thanks to Bernd Helmle from Credativ GmbH for the patch.
  • PSQL: Add automatic rewrite of FOR ... IN REVERSE ... into Pg synthax.
  • Fix column name case sensitivity issue during check constraint export. Thanks to Daniel Berger for the report.
  • Remove the possibility to add comment after a configuration directive it may not be used and it was generating an issue with the passwords configuration directives for examples. Thanks to Daniel Berger for the report.
  • Complete rewrite of user defined type extraction. Add support of inherited type using Oracle UNDER keyword as well as better support to custom type with BODY. Thanks to Mathieu Wingel for the report.
  • Fix case sensitivity on user defined types. Thanks to Mathieu Wingel for the report.
  • UPGRADE: All files have changed so you need a fresh install/upgrade. Previous release used to remove any string starting
  • from a # in the config file, this was to allow comments after a configuration directive. This possibility have been removed
  • in this release so you can no more add comments after a configuration directive.

New in Ora2Pg 8.1 (Mar 29, 2011)

  • Prevent Ora2PG to export twice datas when using FILE_PER_TABLE and the data output file exist. This is useful in case of export failure and you don't want to export all data again. This also mean that if you want to get new data you have to remove the old files before.
  • Fix parsing of procedure/function into pl/sql Oracle package.
  • Fix bug in IS NULL/IS NOT NULL replacement. Thanks to Jean-Paul Argudo from Dalibo for the report.
  • Add CREATE OR REPLACE on RULE creation.
  • Add DROP TRIGGER IF EXISTS before trigger creation.
  • Replace Oracle date "0000-00-00" by NULL.
  • Fix infinite loop in package/fonction type replacement.
  • Add one file per package creation if FILE_PER_FUNCTION is enabled.
  • Fix double quote in name of custom type extraction.
  • Add extraction of custom type IS VARRAY as an custom type of table array. Thank to Jean-Paul Argudo from Dalibo for the patch.
  • Fix multiple double quote in name of create index definition.
  • Apply excluded and limited table to tablespace extraction.
  • Fix function and procedure detection/parsing on package content.
  • Fix schema prefix in function name declaration in package export.
  • PLSQL: Replace some way of extracting date part of a date : TO_NUMBER(TO_CHAR(...)) rewritten into TO_CHAR(...)::integer when TO_NUMBER just have one argument.
  • Fix Makefile.pl error when trying to modify file ora2pg now renamed into ora2pg.pl
  • Add 3 new export types SHOW_SCHEMA, SHOW_TABLE and SHOW_COLUMN. Those new extraction keyword are use to only display the requested information and exit. This allow you to quickly know on what you are going to work. The SHOW_COLUMN allow a new ora2pg command line option: '--xtable relname' or '-x relname' to limit the displayed information to the given table.
  • Add type replacement for BINARY_INTEGER and PLS_INTEGER as integer.

New in Ora2Pg 8.0 (Mar 16, 2011)

  • Remove addition of AS for alias as with modern PG version this can be optional (Pg >= 8.4).
  • Fix CREATE with missing USER/ROLE for grant extraction. Thanks to Herve Girres for the report.
  • Apply missing psql_pgsql converter to view definition.
  • PLSQL : Normalize HAVING ... GROUP BY into GROUP BY ... HAVING clause
  • PLSQL : Convert call to Oracle function add_months() and add_years() into Pg syntax
  • Apply missing psql_pgsql converter to triggers WHEN clause.
  • Fix DECLARE CURSOR rewrite.
  • Allow one file per function / procedure / package exported with a new configuration option FILE_PER_FUNCTION. Useful to editing and testing. Thank to Jean-Paul Argudo from DALIBO for the feature request.
  • The FILE_PER_TABLE configuration option is now also applied to views.
  • Remove obsolete PG_SUPPORTS_INOUT and PG_SUPPORTS_DEFAULT as they are now supported by with modern PG version.
  • Allow to adjust PostgreSQL client encoding with a new configuration directive: CLIENT_ENCODING.
  • Add TRUNCATE_TABLE configuration directive to add TRUNCATE TABLE instruction before loading data.
  • Add type conversion of Oracle XMLTYPE into PostgreSQL xml type.
  • PLSQL: SYSDATE is now replaced by LOCALTIMESTAMP to not use timezone. Thanks to Jean-Paul Argudo from DALIBO for the report.
  • Use 'CREATE OR REPLACE' on create trigger function instruction.
  • Fix prefixing by OUTPUT_DIR when file per table/function is enabled.
  • Use 'CREATE OR REPLACE' on create view.
  • PLSQL_PGSQL is now enabled by default. If you want to export Oracle original function/procedure/package code, disable it.
  • PLSQL: WHERE|AND ROWNUM = N; is automatically replaced by LIMIT N;
  • PLSQL: Rewrite comment in CASE between WHEN and THEN that makes parser unhappy.
  • PLSQL: Replace SQLCODE by SQLSTATE

New in Ora2Pg 7.2 (Jan 14, 2011)

  • Fix export of BLOB/RAW to bytea data import causing import to crash. Thanks to Ozmen Emre Demirkol for the report.
  • Add support to default value into function parameters (PG >= 8.4). Can be activated with a new configuration directive: PG_SUPPORTS_DEFAULT. Default is 1, activated.
  • Fix bad ending of exported function: remove trailing chars after END.
  • Add support to WHEN clause on triggers (PG >= 9.0), activated with a new configuration directive: PG_SUPPORTS_WHEN.
  • Add support to INSTEAD OF usage on triggers (fo incoming PG >= 9.1). Can be activated with a new configuration directive: PG_SUPPORTS_INSTEADOF.
  • Fix error using SKIP directive. Thanks to Laurent Renard from Cap Gemini for the report.
  • Fix missing perl object instance in format_data() function.
  • Fix duplicate procedure or function when export type use both FUNCTION and PROCEDURE.

New in Ora2Pg 7.1 (Dec 6, 2010)

  • Improve direct DBD::Pg data export/import speed by 10.
  • Add --section=3 in pod2man call into Makefile.PL. Thanks to Julian Moreno Patino for the report.
  • Renamed Changelog into changelog to avoid upstream warning with Debian package. Thanks to Julian Moreno Patino for the suggestion.
  • Fix some spelling mistakes in doc/Ora2Pg.pod. Thanks to Julian Moreno Patino for the fix.
  • Fix release version into Ora2Pg.pm and PLSQL.pm, was still in 6.5.
  • Fix direct data export/import using DBD::Pg. Thanks to Laurent Renard from Cap Gemini for the report.
  • Fix drop/create contraints and index during direct data export/import using DBD::Pg. Thanks to Thierry Grasland from Cap Gemini for the report.

New in Ora2Pg 7.0 (Nov 25, 2010)

  • Improve data export speed by 6! The data export code has been entierly rewritten and the speed gain is really fun.
  • Rename ora2pg perl script into ora2pg.pl in sources because Windows users can't extract the tarball. During install it is renamed into ora2pg. Thanks to Andrew Marlow for the report.
  • Fix doinst.sh for SlackWare Slackbuid packaging.
  • The DEFER_FKEY configuration directive has been fixed as it only works in a transaction. Note that foreign keys must have been created as DEFERRABLE or it also will not works. Thanks to Igor Gelman for the report.
  • Add DROP_FKEY configuration directive to force deletion of foreign keys before the import and recreate them and the end of the import. This may help if DEFER_FKEY not works for you.
  • Add DROP_INDEX configuration directive to force deletion of all indexes except the automatic index (primary keys) before data import and to recreate them at end. This can be used to gain speed during import.
  • Add TSMSYS, FLOWS_020100 and FLOWS_FILES to the owners exclude list. This concern the SRS$ table and all tables begining with 'WWV_FLOW_'
  • Change the way DATA_LIMIT is working. It must be used now to set the bulk size of tuples return at once. Default is 10000.
  • Add OUTPUT_DIR configuration directive to set a base directory where all dumped files must be written. Default: current directory.
  • Change value of default numeric(x) type from float to bigint and change default numeric(x,y) type to double precision.
  • Change conversion type for BFILE from text to bytea.

New in Ora2Pg 6.4 (Sep 13, 2010)

  • Configuration directives SHOWTABLEID, MIN and MAX are now obsolete and has been definitively removed.
  • They were never used and add too much confusion.
  • Fix bug in column name replacement where table name was also replaced. Thank to Jean-Paul Argudo from DALIBO for the report.
  • Fix case sensitive errata in PG schema search path. Thank to Jean-Paul Argudo from DALIBO for the report.
  • Remove double \n at end of debug message.
  • Fix debug mode not activated if the DEBUG directive is enable and the -d command line is not present.
  • Add unbuffered output for debug message.

New in Ora2Pg 6.3 (Jul 31, 2010)

  • Fix Oracle 8i compatibility error during schema extraction complaining that column CHAR_LENGTH doesn't exist. Thanks to Philippe Rimbault for the report. Note that the error message is still displayed but tagged as WARNING only.
  • Fix error using the IMPORT option on a read_conf method call. Thanks to Diogo Biazus for the report.
  • Fix export of sequences that does not handle maxvalue well and can be lower than minvalue. Thanks to Nathalie Doremieux for the report.

New in Ora2Pg 6.1 (May 10, 2010)

  • 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.

New in Ora2Pg 6.0 (Mar 1, 2010)

  • This release adds support to Oracle table partitoning. See export type PARTITION. There's also two bugfix, extra double quote on column name of index export and fix miss handling of Ora2Pg.pm options at object instance initialization.
  • The major version upgrade is related to a complete repackaging of the Ora2Pg distribution.

New in Ora2Pg 5.1 (Jun 9, 2009)

  • Fix missing -U username at Pg connection. Thanks to Brendan Richards.
  • Fix $ENV{ORACLE_HOME} and $ENV{NLS_LANG} to not being overwritten by configuration settings if they are already defined in environment.
  • Fix typo in ora2pg.pl where keep_pkey_names was replaced by keep_pkeys_name and so prevent use of KEEP_PKEY_NAMES in configuration. Thanks to Olivier Mazain for the report.
  • Configuration file directives are now case insensitive.
  • Force $type parameter given to _sql_type() to be uppercase in that methode instead of during function call. Thanks to Ali Pouya for the report.
  • Modify ora2pg.pl to remove the obsolete call to export_data(). Use only export_schema() now.
  • Modify ora2pg.pl to simplify it. Reading configuration is now done internally by Ora2Pg.pm as well as all other initialization process. You can always overwrite all configuration options into call to new Ora2Pg(). Now ora2pg.pl can be as simple as:
  • use Ora2Pg;
  • my $schema = new Ora2Pg('config' => "/etc/ora2pg.conf");
  • $schema->export_schema();
  • exit(0);
  • This will be less confusing. You can upgrade Ora2Pg.pm without carring about that, backward compatibility with previous version is preserved.
  • Review entire documentation with the great help of Ali Pouya.
  • Add type BOOLEAN converted to boolean.
  • PG_SUPPORTS_INOUT is now enabled by default in the configuration file
  • SQL and PL/SQL to PLPGSQL converter:
  • Replace MINUS call to EXCEPT
  • Replace DBMS_OUTPUT.put, DBMS_OUTPUT.put_line, DBMS_OUTPUT.new_line by the PLPGSQL equivalent: RAISE NOTICE
  • Rewrite function/procedure/package convertion functions. This Oracle SQL converter for function/procedure/package is now only applied if the configuration directive PLSQL_PGSQL is enable, else these Oracle code are exported as is. Thanks to Ali Pouya for the help.
  • Reserved call to sql transaction only for DATA export type. Others export type now use set ON_ERROR_STOP ON. Thanks to Ali Pouya.
  • Fix tablespace creation into schema (missing search_path). Thanks to Olivier Mazain.
  • Fix the type returned by the _sql_type() method in the case of a numeric with null len and pg_numeric_type is set. Thanks to Ali Pouya. Change function body delimiter to $body$ to allow use of $$ into the body as quote replacement. Thanks to Ali Pouya. Fix returns type from function. If multiple OUT parameters: RECORD, if only one OUT parameter, return his type. If no out parameter: return VOID. Thanks to Ali Pouya.
  • Fix export DATA when the name of a column in the table match COMMENT, AUDIT or any other defined reserved words. These reserved words are defined in a new configuration variable ORA_RESERVED_WORDS. It accept a list of comma separated reserved words. Thanks to Andrea Agosti for the report.
  • Fix configuration parser that omit custom SYSUSERS definition.

New in Ora2Pg 5.0 (Feb 13, 2009)

  • This release fixes some errors on trigger export and adds an initial attempt to convert PLSQL code to PLPGSQL.

New in Ora2Pg 4.11 (Dec 17, 2008)

  • This release adds a configuration option to use case-sensitive Oracle table/view names, and fixes missing schema names in queries during views as table extraction.

New in Ora2Pg 4.10 (Dec 8, 2008)

  • This release adds the ability to extract the views structure as a table schema and to export data from a view as if it were a table.
  • It also fixes missing replacement of table names on disable triggers.

New in Ora2Pg 4.9 (Oct 28, 2008)

  • This release add extraction of a function-based index that appears as SYS_NC, and a new configuration option to not export alter sequence after data export.

New in Ora2Pg 4.8 (Sep 7, 2008)

  • This release adds a SYSUSERS configuration option to exclude more Oracle System users from export.
  • It also adds support for binary mode output other than ":raw", which is useful if you have UTF-8 records.
  • Double escaping of special characters was fixed.