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.01k stars 342 forks source link

Ora2Pg: Error in default subpartition migration #1562

Closed elexus closed 1 year ago

elexus commented 1 year ago

I'm creating default subpartition in table. image

After migration by Ora2Pg it creates subpartiotions, but default refers not to partiotion, but to parent table: image

So if I have couple of partitions, every time creates not default subpartiotion, but default partition.

Maybe I do something wrong?

darold commented 1 year ago

Right, please download and use latest development code I just pushed commit 2b1ddfb7f that fixes that and completely rewrite the way partition and sub-partition are renamed. The PREFIX_PARTITION configuration directive have been renamed into RENAME_PARTITION.

elexus commented 1 year ago

Hi! Error is still there. Posted a new issue. https://github.com/darold/ora2pg/issues/1568