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
978 stars 341 forks source link

partitioned tables copy statement with wrong name #1732

Closed mgerhardy closed 4 months ago

mgerhardy commented 4 months ago

there is a table called history.foobar that is partitioned and the PARTITION_NAME is used for copy

suppose partition name is F_P0001 the table and schema name is not included in the copy statement - but only the partition name

COPY F_P0001 ....

darold commented 4 months ago

The schema is included in the main psql import file. Let's say you have used -o data.sql you must import the all tables data files from this main psql script.