also check out ora_migrator https://github.com/cybertec-postgresql/ora_migrator (another extension from Cybertec) which uses oracle_fdw under the hood.

intro blog post: https://www.cybertec-postgresql.com/en/ora_migrator-moving-f...