David G. Johnston wrote:
> On Wed, Jan 16, 2019 at 1:35 PM Pepe TD Vo <pepevo@yahoo.com> 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