Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AD77F9FA4CF for ; Tue, 17 Oct 2006 07:25:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19433-01 for ; Tue, 17 Oct 2006 07:25:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp3.adl2.internode.on.net (smtp3.adl2.internode.on.net [203.16.214.203]) by postgresql.org (Postfix) with ESMTP id 2C5FD9F9FAC for ; Tue, 17 Oct 2006 07:25:19 -0300 (ADT) Received: from [192.168.8.200] (ppp247-71.static.internode.on.net [203.122.247.71]) by smtp3.adl2.internode.on.net (8.13.6/8.13.5) with ESMTP id k9HAPDP2087016; Tue, 17 Oct 2006 19:55:13 +0930 (CST) (envelope-from pgsql@007Marketing.com) Message-ID: <4534AF88.3050605@007Marketing.com> Date: Tue, 17 Oct 2006 19:55:12 +0930 From: Shane Ambler User-Agent: Thunderbird 1.5.0.7 (Macintosh/20060909) MIME-Version: 1.0 To: Felix Zhang CC: pgsql-general@postgresql.org Subject: Re: Any documatation about porting from Oracle to PostgreSQL References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.955 tagged_above=0 required=5 tests=AWL, BIZ_TLD, SPF_HELO_PASS X-Spam-Level: * X-Archive-Number: 200610/800 X-Sequence-Number: 102326 Felix Zhang wrote: > Hi all, > > I'm a newbie of PostgreSQL. I'm searching materials about porting from > Oracle to PostgreSQL. > Anyone can share with me some good documatations? > > Thanks and regards, > Felix > A quick search of pgfoundry finds http://pgfoundry.org/projects/orafce/ which may help. Depending on your needs and plans have you looked at EnterpriseDB? They claim to run most Oracle stuff straight up. Their free version will run on 1cpu with up to 4GB data and 1GB RAM. -- Shane Ambler Postgres@007Marketing.com Get Sheeky @ http://Sheeky.Biz