Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id BD5556325DB for ; Fri, 30 Jan 2009 10:22:45 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65362-04 for ; Fri, 30 Jan 2009 10:22:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailin.kwsoft.de (mailin.kwsoft.de [213.164.67.82]) by mail.postgresql.org (Postfix) with ESMTP id 8D3E762E7C6 for ; Fri, 30 Jan 2009 10:22:42 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by mailin.kwsoft.de (Postfix) with ESMTP id 89F441A11C for ; Fri, 30 Jan 2009 15:22:39 +0100 (CET) Received: from mailer.kwsoft.de (mailer.kwsoft.de [10.5.0.1]) by webmail.kwsoft.de (Horde Framework) with HTTP; Fri, 30 Jan 2009 15:22:39 +0100 Message-ID: <20090130152239.14884127rk66buio@webmail.kwsoft.de> X-Priority: 3 (Normal) Date: Fri, 30 Jan 2009 15:22:39 +0100 From: lst_hoe02@kwsoft.de To: pgsql-admin@postgresql.org Subject: Re: How to migrate from oracle to postgres !! References: <1233315299.2247.33.camel@dss-052.dsslp.com> In-Reply-To: <1233315299.2247.33.camel@dss-052.dsslp.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; DelSp="Yes"; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.3.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/170 X-Sequence-Number: 31217 Zitat von Suresh Borse : > Dear All, > > How to migrate existing database which in Oracle to postgres? > > Please provide me the solution/limitation for triggers , procedure , > packages & views while migrating. > > > Thanks & Regards, > > Suresh Borse > (DBA) Not long ago someone posted the following link http://wiki.kandalaya.org/cgi-bin/twiki/view/Main/MigratingOracleToPostgreSQL but i honestly don't know how useful it is. Regards Andreas