Re: Oracle Database in Embedded Environments

Marco,

If you are using partitioning, it comes only with Enterprise Edition with
Partitioning option (as an extra cost) on top of it - must be very expensive
for an embedded database.

If you are looking for an alternative, take a look at PostgreSQL.
It is Open Source db, which has partitioning feature, not as advanced as in
Oracle, but still quite usable (and useful).
The other attractive feature of Postgres for you could be the fact that
Postgres procedural language (PlPgSQL) is pretty close to Oracle's PL/SQL.

Regards,
Igor Neyman

On Wed, Aug 3, 2011 at 5:49 AM, Marco . <marcopb@xxxxxxxxx> wrote:

> We have a lot of PL/SQL code written for our product and using features
> such as partitioning and so on.
> Anyway I'm interested in which other candidates are available on the
> market. Could you suggect them, please ?
>
> Regards,
> Marco
>
> On Mon, Jul 18, 2011 at 7:26 PM, Goulet, Richard <Richard.Goulet> wrote:
>
>> It’s an interesting read, but given the cost, complexity, and capabilities
>> of Oracle I don’t think I would choose it as an imbedded database engine.
>> Especially when there are other candidates that are built more to the point.
>> ****
>>
>> ** **
>>
>> Richard Goulet****
>>
>> Senior Oracle DBA/Na Team Leader****
>>
>> ** **
>>
>> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
>> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *marco pb
>> *Sent:* Friday, July 15, 2011 9:08 AM
>> *To:* oracle-l@xxxxxxxxxxxxx
>> *Subject:* Oracle Database in Embedded Environments****
>>
>> ** **
>>
>> It's my first post on oracle-l even if I follow you since two years by RSS
>> :) and I'd like to say hello to all of you.
>>
>> I'm gathering informations about Oracle database embedded solutions and I
>> started reading this link
>> http://www.oracle.com/technetwork/topics/embedded/whatsnew/index.html
>>
>> I know that to sell Oracle database in embedded environments you have to
>> be an Oracle partner and certified to be able to deploy your application
>> with it.
>> The problem is: our account manager "heard" that an embedded oracle
>> database is provided to the customer as is (into the appliance) and it's not
>> possible to manage it by a dba because for example sqlplus is even not
>> installed.
>>
>> Then I read also this pdf
>> http://www.oracle.com/us/technologies/11g-embedded-whitepaper-166560.pdf
>>
>> In my opinion it consists just in a silent but "complete" installation
>> where if you are able to conveniently configure and use the database into
>> the appliance no administrative in-house intervention is required...
>> otherwise the seller (my company in this case) have to solve the problem
>> with their own dba.
>>
>> What is your experience about it ?
>>
>> Regards,
>> Marco****
>>
>
>

Other related posts: