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.
What we have. 3 tables, 1 is usual, 1 has only partitions, 1 has partitions and subpartitions (code is below).
After magration using Ora2Pg (Grant type) I got syntax errors related to partitioned and subpartitioned tables.
Words "PARTITION" and "SUBPARTITION" appear, but they shouldn't.
What we have. 3 tables, 1 is usual, 1 has only partitions, 1 has partitions and subpartitions (code is below). After magration using Ora2Pg (Grant type) I got syntax errors related to partitioned and subpartitioned tables. Words "PARTITION" and "SUBPARTITION" appear, but they shouldn't.
Oracle code:
Postgresql code: