David G. Johnston wrote: > On Wed, Jan 16, 2019 at 1:35 PM Pepe TD Vo <pepevo@xxxxxxxxx> wrote: > > Need to download oracl-fdw? > > oracle-fdw is PostgreSQL Server software that allows the PostgreSQL > server to connect to the Oracle database directly as a client. It can > move data but doesn't really deal with schema...it likely is something > you can forget and focus on migrating data and schema simultaneously > with a product designed to do just that (which ora2pg seems to be). You can use https://github.com/cybertec-postgresql/ora_migrator which will migrate metadata as well using oracle_fdw. Pepe, at your level of knowledge I would recommend that you hire a consultant to help you, regardless if you want to use ora2pg or something else. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
