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.
Fix for Issue #1612 by making the Oracle schema and table name quoted identifiers in the SELECT COUNT(*) ... statement.
Note: this means that the lower-case comparison of the PostgreSQL and Oracle object names will not match exactly in line 17026 of subroutine set_pg_relation_name:
$orig = " (origin: $table)" if (lc($cmptb) ne lc($table));
And the resulting output will show something similar to:
Which is probably fine as it shows the object names with quoted accuracy. However, if not desirable, this the comparison of lc($table) in line 17026 could be modified to strip the double quotes.
Fix for Issue #1612 by making the Oracle schema and table name quoted identifiers in the
SELECT COUNT(*) ...
statement.Note: this means that the lower-case comparison of the PostgreSQL and Oracle object names will not match exactly in line 17026 of subroutine set_pg_relation_name:
And the resulting output will show something similar to:
Which is probably fine as it shows the object names with quoted accuracy. However, if not desirable, this the comparison of
lc($table)
in line 17026 could be modified to strip the double quotes.