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
1.02k stars 343 forks source link

Ora2Pg: Default subpartition migration error #1568

Closed elexus closed 1 year ago

elexus commented 1 year ago

Hi, Darold. You said, that you fixed our problem, but it's still there: The problem not is in naming of partitions and subpartitions, but in referencing on parent table. For example: "DEF" is partition of "ABC" and we create subpartitions "DEF_1", "DEF_2" and "DEF_3" of "DEF" And when we create default subpartition "DEF_default" it references not "DEF", but "ABC"!!

As the result, we expected to see a lot of partitions, each of them had subpartitions including default, however we got a lot of default partitions of main table, what caused an error.

Previous Issue: https://github.com/darold/ora2pg/issues/1562

Here is the code-source and migrated code:

image

migrated to

image

darold commented 1 year ago

Hi, if you want me to solve such issue, I need to be able to reproduce and screenshot doesn't really help. What I need is a copy/paste DDL to be able to create the objects in Oracle quickly, if I have to write a use case by myself there is chance that I will never do that. As you see with the response delay time is a huge problem for me. Thanks for your understanding.