Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: EnterpriseDB

RE: EnterpriseDB

From: Igor Neyman <>
Date: Wed, 21 Feb 2007 10:19:00 -0500
Message-ID: <>

Small correction.
In PG the database can have multiple tablespaces (just one - default). You can specify tablespace as "storage" parameter when creating a table, if not specified - it goes into "default" tablespace. The biggest "eye-opener" for me was the fact, that in PG every table is stored in a separate file.


-----Original Message-----

[] On Behalf Of Richard J. Goulet Sent: Wednesday, February 21, 2007 9:55 AM To:; Oracle-L List
Subject: RE: EnterpriseDB

YES, It's not a bad product, but there is a substantial amount of reading between the lines that you'll need doing. The underlying technology is PostGreSql which you can acquire for free from Migration is simple as they fully support functions and some procedures. I didn't see packages in PostGreSql so I believe EnterpriseDB's migration tool breaks them up into separate entities. Also PostGreSql's interpretation of tablespaces is different that ours. Where as in Oracle a database can have multiple tablespaces in postgresql they can have only one, but different databases can each have a separate tablespace or storage location. A lot better than MySql or Sql*Server, but not quite the same as Oracle. Also if your into clustering or replication your either stuck (no clustering yet in PostGreSql) or you have to use a third party tool which are also open sourced so not a really big deal. It works really great for decision support or trend analysis, or even a customer facing application like order status stuff. No it would not run an SAP or E-Business Suite like application very well and I would not want to store sensitive data therein either. But it is an attractive alternative to Oracle from a cost perspective. And acquiring it from EnterpriseDB vs. does give you a phone number to call when the mess hits the fan.  

Dick Goulet, Senior Oracle DBA

45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795

-----Original Message-----

[] On Behalf Of Ray Feighery Sent: Wednesday, February 21, 2007 12:46 AM To: Oracle-L List
Subject: EnterpriseDB

Has anyone used this?

"EnterpriseDB offers an enterprise-class alternative to Oracle at a fraction of the cost.
Making the switch from Oracle requires little or no modification to existing applications. Using our Migration Toolkit, the process is often completed in minutes. In fact, our clients report that more than 75% of their applications are 100% compatible, requiring NO changes to run on EnterpriseDB.
Some EnterpriseDB clients choose to entirely replace Oracle; others use our databases as a more efficient alternative for specific applications and reports.
EnterpriseDB Advanced Server is based on PostgreSQL"



-- Received on Wed Feb 21 2007 - 09:19:00 CST

Original text of this message