Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: EnterpriseDB as an Oracle replacement

RE: EnterpriseDB as an Oracle replacement

From: David Green <>
Date: Thu, 6 Sep 2007 18:55:43 -0700
Message-ID: <000f01c7f0f2$369736e0$a3c5a4a0$@org>

What version did you eval?

8.2 made huge strides in the right direction and 8.3 will go further towards improving the "compatibility" and inclusion of more coolness.

The EDB partitioning model is closer in comparison to the old school partition views with check constraints model we used to have to employ under Oracle the right direction and 8.3 will    

From: [] On Behalf Of Roby Sherman
Sent: Wednesday, September 05, 2007 7:00 PM To:
Cc: oracle-l
Subject: Re: EnterpriseDB as an Oracle replacement  

We evaluated it a few months ago and found that the compatibility was not great in several areas. In the case of PL/SQL stored procedures, for example, they lacked support even for the most basic things that we were looking for, such as:  

Obviously this isn't the full and comprehensive list and, perhaps, you don't care about PL/SQL compatibility, but if you have other areas you are concerned about, shoot me an e-mail and I'll try to share what I can.    


On Sep 5, 2007, at 6:56 PM, Ben Poels wrote:

I know many people have mentioned in the past that they find Postgres a

viable alternative to Oracle for many uses. Now there is EnterpriseDb which

is based on Postgres but takes it one step further and claims it is Oracle

compatible. It even has range partitioning w/o the extra $$$. They are

touting FTD, Vonage and Sony's gaming division as major users.  

Is anyone using EnterpriseDB for there non-critical databases to save money

on licensing? If you are, how accurate are the compatibility claims? I know

it doesn't support XMLTYPE and private synonyms for instance. Anyone done

any benchmarks?  








|  Roby Sherman  ( r x s h e r m @ i n t e r e a l m . c o m )

|  DBA, Architect, Computer Scientist, Pain in the keister




| A computer without a Microsoft operating system is like a dog without
bricks tied to it's head                                  




Received on Thu Sep 06 2007 - 20:55:43 CDT

Original text of this message