How to manage reference partitions in oracle while migrating to azure postgres using ora2pg

Question

Hi Team,

In Technical white paper provided by azure team, reference partitioning in oracle is mentioned as available in postgresql. But while trying to migrate using ora2pg, we are getting table script generated as -- Unsupported partition type, please check. Kindly help with any documentation which helps us to migrate Reference partitioning from Oracle to postgresql or any approach which you will suggest for the same.

Thanks and regards,
Manimahesh S

Answer 1

Thanks, @Mani Mahesh S for providing the details.
There is an error in the whitepaper, Unfortunately, Postgres does not support reference partitioning. You might want to migrate it to hash partitions or add a column and populate data but that would require app change.

Please let me know if you need any additional information.

Regards
Geetha