Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

We recommend ORA2PG - http://ora2pg.darold.net/ - for data instantiation from Oracle database to Postgres. There are server several other tools for this purpose. However, those aren't free of charge. You can find them at https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Oracle. This tool can be used on Unix based OS or Windows.

...

  • PostgreSQL server or PostgreSQL client is pre-installed on your server. Else download it using yum (yum install postgresql-server or yum install postgresql) or from "https://www.postgresql.org/download/linux/redhat/" if you want use specific version. 

    Code Block
    [root@target11g data]# yum install postgresql


...

  1. Export tables DDL from Oracle
  2. Import DDL to Postgres
  3. Copy the data

1. Export DDL from Oracle

...