OraFAQ Forum: Replication » which edition is better EE vs SE vs SE1

Home » Server Options » Replication » which edition is better EE vs SE vs SE1 (Oracle 10g release 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

which edition is better EE vs SE vs SE1 [message #437191]

Thu, 31 December 2009 19:44

abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal

Member

I need to do full database replication in around 25 servers.
all of them will hold teh same data n structure(exact replica).
but to get enterprise edition it is way expensive for our company.
So what will be the better option? Can we use Standard edition/standard edition one and do replication or not? and whether table partitioning is supported in SE/SE1 or not?
what will be the performance differences? please reply me soon i need to submit the research tomorrow?

Report message to a moderator

Re: which edition is better EE vs SE vs SE1 [message #437192 is a reply to message #437191]

Thu, 31 December 2009 20:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>and whether table partitioning is supported in SE/SE1 or not?
partitioning is only available with Enterprise Edition.

Report message to a moderator

Re: which edition is better EE vs SE vs SE1 [message #437194 is a reply to message #437192]

Thu, 31 December 2009 22:39

abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal

Member

what about database replication.....????
I need to do it as well...

Report message to a moderator

Re: which edition is better EE vs SE vs SE1 [message #437195 is a reply to message #437194]

Thu, 31 December 2009 22:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

abhi_shakya wrote on Thu, 31 December 2009 20:39

what about database replication.....????
I need to do it as well...

"database replication" means different things to different people.
Since you did not provide detailed requirements regarding exact capabilities needed, I declined to waste my time speculating possible solutions; which may or may not do what you desire.

Some "data" replication can be done by SE & some other capabilities require EE.

It does not matter to me whether SE meets your needs or not.

Report message to a moderator

Re: which edition is better EE vs SE vs SE1 [message #437209 is a reply to message #437195]

Fri, 01 January 2010 10:52

abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal

Member

i need to have 25 database systems with exact replica...can i achieve that in SE1 or not? please help me out....
There will be one central database and 24 more database with same data as in the central database....can i achieve this in Oracle SE1....

Report message to a moderator

Re: which edition is better EE vs SE vs SE1 [message #437210 is a reply to message #437209]

Fri, 01 January 2010 11:23

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why don't you ask to Oracle?
They are there to answer this kind of questions.

Regards
Michel

Report message to a moderator

Previous Topic:	A question about CREATE PUBLIC DATABASE LINK and ORA-12154 error
Next Topic:	How to replicate

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 14:06:20 CST 2025