vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| in article c8dL9.4001$jM5.11318@newsfeeds.bigpond.com, Howard J. Rogers at howardjr2000@yahoo.com.au wrote on 12/15/02 9:12 PM: > Well, snapshot replication was renamed in 8i to be 'materialized view > replication', and materialized views are specific to the Enterprise Edition. > > So no, Standard Edition won't do. > > HJR Hmm - actually, materialized views are in both editions. Query rewrite to use the MV, however, is ony in Enterprise. So bulk standard read on;y snapshot replication is supported in both. > "Ray Teale" <ray@BLAHholly.com.au> wrote in message > news:vibL9.306$Qk5.4011@nnrp1.ozemail.com.au... >> I'm preparing a proposal for some software and would like to know if >> bog-standard read-only snapshot replication is available for the Standard >> edition of version 8.1.x for Solaris or do they need Enterprise licences. >> >> Regards >> >> Ray >> >> > > |
| |||
| Hmmm. Quite right. I should have checked http://otn.oracle.com/products/oracle8i/pdf/8i_fam.pdf which makes it abundantly clear that 8i supports pretty much all replication, bar multi-master replication. My mistake. And thanks for correcting me. Regards HJR "Mark Townsend" <markbtownsend@attbi.com> wrote in message news:BA22B046.4476%markbtownsend@attbi.com... > in article c8dL9.4001$jM5.11318@newsfeeds.bigpond.com, Howard J. Rogers at > howardjr2000@yahoo.com.au wrote on 12/15/02 9:12 PM: > > > Well, snapshot replication was renamed in 8i to be 'materialized view > > replication', and materialized views are specific to the Enterprise Edition. > > > > So no, Standard Edition won't do. > > > > HJR > > Hmm - actually, materialized views are in both editions. Query rewrite to > use the MV, however, is ony in Enterprise. So bulk standard read on;y > snapshot replication is supported in both. > > > "Ray Teale" <ray@BLAHholly.com.au> wrote in message > > news:vibL9.306$Qk5.4011@nnrp1.ozemail.com.au... > >> I'm preparing a proposal for some software and would like to know if > >> bog-standard read-only snapshot replication is available for the Standard > >> edition of version 8.1.x for Solaris or do they need Enterprise licences. > >> > >> Regards > >> > >> Ray > >> > >> > > > > > |
| |||
| Actually I noticed on further reading that the check table in the document suggests that "Single Master Replication" is supported in Standard but materialized views are not. How come? Ray "Howard J. Rogers" <howardjr2000@yahoo.com.au> wrote in message news:SbiL9.4234$jM5.11415@newsfeeds.bigpond.com... > Hmmm. > > Quite right. I should have checked > http://otn.oracle.com/products/oracle8i/pdf/8i_fam.pdf which makes it > abundantly clear that 8i supports pretty much all replication, bar > multi-master replication. > > My mistake. And thanks for correcting me. > > Regards > HJR > > > "Mark Townsend" <markbtownsend@attbi.com> wrote in message > news:BA22B046.4476%markbtownsend@attbi.com... > > in article c8dL9.4001$jM5.11318@newsfeeds.bigpond.com, Howard J. Rogers at > > howardjr2000@yahoo.com.au wrote on 12/15/02 9:12 PM: > > > > > Well, snapshot replication was renamed in 8i to be 'materialized view > > > replication', and materialized views are specific to the Enterprise > Edition. > > > > > > So no, Standard Edition won't do. > > > > > > HJR > > > > Hmm - actually, materialized views are in both editions. Query rewrite to > > use the MV, however, is ony in Enterprise. So bulk standard read on;y > > snapshot replication is supported in both. > > > > > "Ray Teale" <ray@BLAHholly.com.au> wrote in message > > > news:vibL9.306$Qk5.4011@nnrp1.ozemail.com.au... > > >> I'm preparing a proposal for some software and would like to know if > > >> bog-standard read-only snapshot replication is available for the > Standard > > >> edition of version 8.1.x for Solaris or do they need Enterprise > licences. > > >> > > >> Regards > > >> > > >> Ray > > >> > > >> > > > > > > > > > > |
| ||||
| On Mon, 23 Dec 2002 11:38:14 +1100, "Ray Teale" <ray@BLAHholly.com.au> wrote: >Actually I noticed on further reading that the check table in the document >suggests that "Single Master Replication" is supported in Standard but >materialized views are not. How come? > >Ray If you want to question Oracle's marketing decisions and licensing policy, you'd better get in touch directly with Oracle Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address |