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

Fix for Issue #1617 #1620

Closed simonpane closed 1 year ago

simonpane commented 1 year ago

Fix to problem as described in detail in Issue #1617 . Specifically:

  1. Eliminate training carriage return with the row count value by using a chomp.
  2. Remove quotes from the owner and table names (quoted identifier) and split the table name string -- which as per pull request #1619 will mean that the $tb table name variable does include the schema and is quoted.
  3. Update the proper table name value in the $tables_infos hash but only if both the $ora_table hash key and $ora_owner hash value matches.