Re: Migrate from Oracle 12g to PostgreSQL 9.3

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: "Gust, Thorsten" <thorsten(dot)gust(at)spiegel(dot)de>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Migrate from Oracle 12g to PostgreSQL 9.3
Date: 2017-10-25 18:40:48
Message-ID: CAOBaU_Zhs3aVrbHWpgpt1yMwzp3ACd5-EYqj6+0GRv9Ca4atsw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Oct 25, 2017 at 3:19 PM, Gust, Thorsten
<thorsten(dot)gust(at)spiegel(dot)de> wrote:
> I’m looking for a solution regarding migrate a user from Oracle DB to
> PostgreSQL having the same permissions, Tablespace Quota, Table Privileges,
> Roles and so on afterwards.

You should try http://ora2pg.darold.net/, it handles many things automatically.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Barwick 2017-10-26 02:18:07 Re: Migrate from Oracle 12g to PostgreSQL 9.3
Previous Message Marcin Koziej 2017-10-25 18:20:34 Re: Bad recovery: no pg_xlog/RECOVERYXLOG