Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id C42CE4768EE for ; Tue, 7 May 2002 10:11:53 -0400 (EDT) Received: from harbinger.sirma.bg (harbinger.sirma.bg [62.213.161.140]) by postgresql.org (Postfix) with ESMTP id E7C6A475FB4 for ; Tue, 7 May 2002 09:50:11 -0400 (EDT) Received: (from root@localhost) by harbinger.sirma.bg (8.9.3/8.9.3) id QAA26965; Tue, 7 May 2002 16:49:45 +0300 Received: from redhat.sirma.bg (mail.sirma.bg [62.213.161.133]) by harbinger.sirma.bg (8.9.3/8.9.3) with ESMTP id QAA26956; Tue, 7 May 2002 16:49:43 +0300 Received: from pillango (pillango.sirma.int [192.168.128.42]) by redhat.sirma.bg (8.9.3/8.9.3) with SMTP id QAA03153; Tue, 7 May 2002 16:49:47 +0300 Message-ID: <007801c1f5ce$0a556040$9ba1d53e@sirma.bg> From: "Marin Dimitrov" To: "Jean-Paul ARGUDO" Cc: References: <20020507074618.GB8582@pastis> Subject: Re: [ADMIN] [DOCS] Migrating Oracle to PostgreSQL Date: Tue, 7 May 2002 16:49:42 +0300 Organization: Sirma AI MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Virus-Scanned: X-Archive-Number: 200205/257 X-Sequence-Number: 24237 ----- 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. "