Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3 - Mailing list pgsql-admin

From Julien Rouhaud
Subject Re: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3
Date
Msg-id CAOBaU_Zhs3aVrbHWpgpt1yMwzp3ACd5-EYqj6+0GRv9Ca4atsw@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3  ("Gust, Thorsten" <thorsten.gust@spiegel.de>)
Responses Re: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3  ("Gust, Thorsten" <thorsten.gust@spiegel.de>)
List pgsql-admin
Tree view 
On Wed, Oct 25, 2017 at 3:19 PM, Gust, Thorsten
<thorsten.gust@spiegel.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.


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Marcin Koziej
Date:
Subject: Re: [ADMIN] Bad recovery: no pg_xlog/RECOVERYXLOG
Next
From: Ian Barwick
Date:
Subject: Re: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3