Home » Other » General » Oracle 11g and Enterprise DB Postgres (Oracle 11g )
Oracle 11g and Enterprise DB Postgres [message #477680] Sun, 03 October 2010 11:01 Go to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
We are currently using Oracle but our Management came up with the idea of moving to Enterprise DB.What are the advantage of Oracle over Enterprise DB?
Re: Oracle 11g and Enterprise DB Postgres [message #477681 is a reply to message #477680] Sun, 03 October 2010 11:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What are the advantage of Oracle over Enterprise DB?
What feature does Oracle DB have & that your organization REQUIRES that Enterprise DB not have?
Re: Oracle 11g and Enterprise DB Postgres [message #477682 is a reply to message #477681] Sun, 03 October 2010 11:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or does Oracle have not and Postgres have?
In short, how does come this idea of changing?

Regards
Michel
Re: Oracle 11g and Enterprise DB Postgres [message #477689 is a reply to message #477682] Sun, 03 October 2010 14:41 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
This is because of Oracle licensing cost involved and this is the reason for change.What is the advantage of spending huge amount on Oracle ?
Re: Oracle 11g and Enterprise DB Postgres [message #477786 is a reply to message #477689] Mon, 04 October 2010 08:27 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

And again another company who hasen't a clue why the bought the product in the first place.
Re: Oracle 11g and Enterprise DB Postgres [message #477924 is a reply to message #477680] Tue, 05 October 2010 04:52 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
I still hope to find a proper response from some expert here.Yes we had no option before so we got Oracle but now when there is an option which saves money then the question is why to go for Oracle?
Re: Oracle 11g and Enterprise DB Postgres [message #477928 is a reply to message #477924] Tue, 05 October 2010 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
why to go for Oracle

Because it is the leader.

Regards
Michel
Re: Oracle 11g and Enterprise DB Postgres [message #477936 is a reply to message #477924] Tue, 05 October 2010 05:12 Go to previous messageGo to next message
Frank
Messages: 7893
Registered: March 2000
Senior Member
Why do you say you had no option previously? What changed?
Re: Oracle 11g and Enterprise DB Postgres [message #477944 is a reply to message #477680] Tue, 05 October 2010 05:51 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
"Because it is the Leader" is only a Marketing term and not technical.I cannot tell my Management to spend $100000 on Oracle only because its the Leader Laughing
When i said we had no option i mean there was no other database which provide Active Clustering and something which is Enterprise ready for production but now EnterpriseDB claims it has all features as oracle then why should someone pay such a huge amount for Oracle licensing?
Re: Oracle 11g and Enterprise DB Postgres [message #477945 is a reply to message #477944] Tue, 05 October 2010 05:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It was a joke, I could say because it is the one that the most options and features.
I don't think that Postgres has all SQL functions Oracle has.
I don't think Postgres allows rolling application upgrade.
...

Regards
Michel

[Updated on: Tue, 05 October 2010 08:40]

Report message to a moderator

Re: Oracle 11g and Enterprise DB Postgres [message #477956 is a reply to message #477680] Tue, 05 October 2010 06:32 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
Thanks for the reply Michael.
The 2 points which you mentioned are supported also by EnterpriseDB

http://downloads.enterprisedb.com/whitepapers/Oracle%20Compatibility%20White%20Paper.pdf
Re: Oracle 11g and Enterprise DB Postgres [message #477961 is a reply to message #477956] Tue, 05 October 2010 06:52 Go to previous messageGo to next message
Frank
Messages: 7893
Registered: March 2000
Senior Member
How about support when your database crashes and you lose access/control over your valuable data?
I don't know nothing about Postgres' support options, but I do know Oracle's are quite good with respect to that.
Re: Oracle 11g and Enterprise DB Postgres [message #477983 is a reply to message #477956] Tue, 05 October 2010 08:49 Go to previous message
Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is said in the document you pointed:
Quote:
Postgres Plus supports the following SQL-callable functions and variables which are popular with Oracle developers and DBAs:

Then a list of 32 fucntions, Oracle SQL contains 250 functions (yes I count them in SQL Reference manual).
Does Postgres supports XML queries?
Does it support recursive and hierarchival queries?
...

Quote:
EnterpriseDB supports the most used packages that are built into the Oracle database.

That is many of them are not supported and so have to be rewritten (if it is possible, can you write a package to send a mail? can you write a package that allows you to synchronize different sessions?...).

Everywhere in the document it is said "EnterpriseDB supports the most commonly used XXX" which means many of them are not supported. Now it depends if you use them or not, if you use them you are in some trouble.

I don't see anything about application rolling upgrade which is for me the top 1 Oracle 11.2 new feature.

Regards
Michel

[Updated on: Tue, 05 October 2010 08:50]

Report message to a moderator

Previous Topic: information about oracle
Next Topic: Problem with SPFILE
Goto Forum:
  


Current Time: Mon Aug 15 13:51:19 CDT 2022