OraFAQ Forum: Replication » Replication with Standard Edition?

Home » Server Options » Replication » Replication with Standard Edition?

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

Replication with Standard Edition? [message #148212]

Wed, 23 November 2005 02:32

tomys
Messages: 2
Registered: November 2005

Junior Member

Hi,

is it possible to setup a standby database with oracle snapshot and replication methods?

Can this be done with the script here:
http://www.orafaq.com/scripts/index.htm#ADVREP

and the information here:
http://www.orafaq.com/faqrepl.htm

Or does we need Enterprise Edition?

Regards,
Thomas

Report message to a moderator

Re: Replication with Standard Edition? [message #148217 is a reply to message #148212]

Wed, 23 November 2005 03:05

Frank Naude
Messages: 4590
Registered: April 1998

Senior Member

Maybe. To quote the Oracler Licensing Guide:

"Basic replication (which is available with Standard Edition and Standard Edition One) provides support for read-only and updatable materialized views (for replication) and multitier materialized views. Standard Edition and Standard Edition One databases can also act as a master site for materialized views, but cannot participate in multimaster replication."

Best regards.

Frank

Report message to a moderator