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.
When I supply a file containing a list of table names as the -a parameter, the first row of this file appears to be skipped by ora2pg. Have seen this behavior 3 ways so far:
COPY: table name on first row is neither scanned nor copied
SHOW_TABLE: table name on first row is not shown
SHOW_TABLE: if I add a blank first row, all tables show as expected
Is this just a formatting mistake on my part? I didn't see explicit directions for how that file should look.
When I supply a file containing a list of table names as the
-a
parameter, the first row of this file appears to be skipped by ora2pg. Have seen this behavior 3 ways so far:Is this just a formatting mistake on my part? I didn't see explicit directions for how that file should look.