Re: [ADMIN] [DOCS] Migrating Oracle to PostgreSQL

From: "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg>
To: "Jean-Paul ARGUDO" <jean-paul(dot)argudo(at)IDEALX(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: [ADMIN] [DOCS] Migrating Oracle to PostgreSQL
Date: 2002-05-07 13:49:42
Message-ID: 007801c1f5ce$0a556040$9ba1d53e@sirma.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-docs pgsql-general pgsql-ports pgsql-sql


----- Original Message -----
From: "Jean-Paul ARGUDO"

>
> Sorry to answer so lately!
>
> I made some of this migrations. From Oracle 7 to 8i databases.
>
> Basicaly, have a look at Gilles Darold's tool called ora2pg. You'll find
> this tool under /contrib/oracle/ in PG sources. Or maybe, using a

has anyone successfully used it with 9i?

because it never worked for me - in fact I don't think the error had
anything to do with 9i, it looked more like the script fails to handle
certain cases properly

thanx,

Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bojan Belovic 2002-05-07 14:22:03 db recovery (FATAL 2)
Previous Message Tom Lane 2002-05-07 13:38:17 Re: Dying PostgreSQL backend

Browse pgsql-docs by date

  From Date Subject
Next Message Niall Brady 2002-05-14 12:08:48 Change of link on http://www.postgresql.org/interfaces.html
Previous Message Jean-Paul ARGUDO 2002-05-07 07:46:18 Re: [DOCS] Migrating Oracle to PostgreSQL

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-05-07 14:02:01 Re: postgresql 7.1.3
Previous Message Francisco Reyes 2002-05-07 13:48:13 Re: Index usage vs large repetitions of key

Browse pgsql-ports by date

  From Date Subject
Next Message Tom Lane 2002-05-07 13:54:19 Re: qnx port
Previous Message Dmitry A. Mordovin 2002-05-07 12:53:10 Complete install

Browse pgsql-sql by date

  From Date Subject
Next Message Bojan Belovic 2002-05-07 14:22:03 db recovery (FATAL 2)
Previous Message Oleg Bartunov 2002-05-07 11:54:01 Re: Optimizing the implementation of an optimized tree