search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
991 stars 342 forks source link

Multi table copy. Error: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Oracle::db handle (DESCRIPTION ...) at C:/strawberry/perl/vendor/lib/DBD/Oracle.pm line 364 #1623

Closed redrugin closed 1 year ago

redrugin commented 1 year ago

Hello. I want to copy multiple tables. In my configuration file, I specified them in block "ALLOW". For example:

ALLOW T_TM_BASE,T_TM_CONTACTS_BASE DATA_EXPORT_ORDER T_TM_BASE,T_TM_CONTACTS_BASE

But after successfully copying the first table "T_TM_BASE", I get the error: error_screen

In file "Oracle.pm" on line 364: DBD::Oracle::st::_prepare($sth, $statement, @attribs) or return undef;

I am using the latest versions: ora2pg-23.2 and strawberry-perl-5.32.1.1-32bit. I use windows 11 for execute copy.

What could be the reason for the error?

redrugin commented 1 year ago

Find answer by https://github.com/darold/ora2pg/issues/533 Need to decrease the value "DATA_LIMIT"