375 18193
Madison Pruet wrote: no - it's comp.databases. ibm-db2 and comp.databases. informix AND comp.databas es
You will find the ability to read of great value if your career is in IT. And you are not correct. Perhaps your reader is truncated the name but it is indeed c.d.o.server. --
ARGGGGGGHHHH!!!
Dang it - you're right. #%$#@#$*()@@#$& %((($(#$$
Yeah like I don't totally embarrased myself on a regular basis.
For example my mangled verbiage above.
--
Daniel A. Morgan http://www.psoug.org da******@x.wash ington.edu
(replace x with u to respond)
On Mon, 01 Aug 2005 00:10:29 -0700, Noons interested us by writing: DA Morgan wrote: Madison Pruet wrote: > I didn't know that Oracle replication was available on the standard edition. > I thought that it was only available on the enterprise edition. Am I > mistaken?
1. Please don't top post. 2. You are correct.
He's correct in that he's mistaken. Snapshot replication (basic replication) *is* available in Standard Edition, 9i. Advanced replication (master2master) is only in EE. 10g might have changed that, but that will be another reason for people not to upgrade...
Just to expand on that a bit:
a) from the Oracle9i R2 New Features manual:
-----------------
Basic replication - SE and EE
Oracle9iserver fully supports bi-directional replication with automated
conflict detection and resolution. Supported configurations include a
single updatable master site with multiple updatable or read-only snapshot
sites.
Advanced Replication - EE only
Advanced replication includes basic replication functionality plus
multi-master replication, Replication Manager, and parallel propagation to
maximize throughput. (Advanced Replication was formerly known as
Replication.)
-----------------
b) from the Oracle® Database Licensing Information manual for 10g
-----------------
Advanced Replication (multimaster) - EE only
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.
-----------------
--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard _at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***
HansF wrote: On Mon, 01 Aug 2005 00:10:29 -0700, Noons interested us by writing:
DA Morgan wrote:
Madison Pruet wrote:
I didn't know that Oracle replication was available on the standard edition. I thought that it was only available on the enterprise edition. Am I mistaken?
1. Please don't top post. 2. You are correct.
He's correct in that he's mistaken. Snapshot replication (basic replication) *is* available in Standard Edition, 9i. Advanced replication (master2master) is only in EE. 10g might have changed that, but that will be another reason for people not to upgrade...
Just to expand on that a bit:
a) from the Oracle9i R2 New Features manual:
----------------- Basic replication - SE and EE
Oracle9iserver fully supports bi-directional replication with automated conflict detection and resolution. Supported configurations include a single updatable master site with multiple updatable or read-only snapshot sites.
Advanced Replication - EE only
Advanced replication includes basic replication functionality plus multi-master replication, Replication Manager, and parallel propagation to maximize throughput. (Advanced Replication was formerly known as Replication.) -----------------
b) from the Oracle® Database Licensing Information manual for 10g
----------------- Advanced Replication (multimaster) - EE only
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. -----------------
Thanks.
--
Daniel A. Morgan http://www.psoug.org da******@x.wash ington.edu
(replace x with u to respond)
"bka" <ba*******@yaho o.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. . Replicaton to/from Oracle has nothing do with Enterprise and/or standard edition - to replicate to Oracle or SQL Server, you need IBM Information Integator.
On minaframe, you need to buy a matching nut for every screw you purchased.
Madison Pruet wrote: Does Oracle snapshot replication
1) replicate all of the trigger activity performed on the original table 2) distinguish between updates on a row and inserts/deletes on the same row? (If not, then cascade deletes are not properly performed) 3) properly handle cascading updates
If I understand your question correctly, that is not possible
with ANY replication in any database version.
Traditionaly, when one replicates a table, one only wants the data
of that table. What you are saying is that the entire schema
potentially dependent on that table might also need to be replicated?
If so, I suggest you look at Dataguard: it's the appropriate product
to achieve it and yes, it does the lot. To try and do that with
replication is to pay a huge overhead to achieve something that can
be done a lot more efficiently with different technology.
This is why I generally don't consider snapshot copies as being replication. They generally only replicate the data, and not the engine logic associated with the base table.
Well, have a look at the Oracle doco. Replication has at least three
flavours nowadays (four if you count Dataguard): basic, advanced and
streams.
Streams is the most powerful, but being new you may pay a price in it
not being entirely debugged. Of course I'm not suggesting that Oracle
software is anything but perfect... ;)
The other two are just traditional replication subsets.
Have a look at Hans' reply, he details each of the two and
there is no point in me repeating. Even with basic replication,
you still get CRUD. But you won't get elaborate cascading dependencies.
Nor trigger effect cascading. For that sort of replication, Dataguard
is the answer.
Madison Pruet wrote: no - it's comp.databases. ibm-db2 and comp.databases. informix AND comp.databases
You will find the ability to read of great value if your career is in IT. And you are not correct. Perhaps your reader is truncated the name but it is indeed c.d.o.server. --
ARGGGGGGHHHH!!!
Dang it - you're right. #%$#@#$*()@@#$& %((($(#$$
ker-chink!
;)
"Noons" <wi*******@yaho o.com.au> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. . Madison Pruet wrote: Does Oracle snapshot replication
1) replicate all of the trigger activity performed on the original table 2) distinguish between updates on a row and inserts/deletes on the same
row? (If not, then cascade deletes are not properly performed) 3) properly handle cascading updates
If I understand your question correctly, that is not possible with ANY replication in any database version. Traditionaly, when one replicates a table, one only wants the data of that table. What you are saying is that the entire schema potentially dependent on that table might also need to be replicated?
If so, I suggest you look at Dataguard: it's the appropriate product to achieve it and yes, it does the lot. To try and do that with replication is to pay a huge overhead to achieve something that can be done a lot more efficiently with different technology.
Noons --- IBM Informix Enterprise Replication supports this functionality
with about 1/3 the overhead of the original transaction.
Madison Pruet wrote: Noons --- IBM Informix Enterprise Replication supports this functionality with about 1/3 the overhead of the original transaction.
Madison:
I've long ago stopped believing in fairies, godmothers
and other garden variety gnomes.
Spare me the "mine is longer than yours", I don't give
a rat's arse what Informix does, under or not IBM.
Tah?
"Noons" <wi*******@yaho o.com.au> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. . Madison Pruet wrote:
Noons --- IBM Informix Enterprise Replication supports this
functionality with about 1/3 the overhead of the original transaction.
Madison: I've long ago stopped believing in fairies, godmothers and other garden variety gnomes. Spare me the "mine is longer than yours", I don't give a rat's arse what Informix does, under or not IBM. Tah?
Then why are you posting in comp.databases. informix?
You stated -
"If I understand your question correctly, that is not possible
with ANY replication in any database version."
That is simply not true. Now it may be true with the database that you are
using, but it is not true with IDS ER. There are replication solutions which
do support these functionalities , and yes - Informix ER does support them
with about 1/3 of the overhead of the original transaction.
I'm not playing any "mine is longer than yours" game. I'm simply pointing
out an incorrect statement which you made.
On 2 Aug 2005 17:54:03 -0700, "Noons" <wi*******@yaho o.com.au> wrote: Madison Pruet wrote:
Noons --- IBM Informix Enterprise Replication supports this functionality with about 1/3 the overhead of the original transaction.
Madison: I've long ago stopped believing in fairies, godmothers and other garden variety gnomes. Spare me the "mine is longer than yours", I don't give a rat's arse what Informix does, under or not IBM. Tah?
Ah, intellectual honesty . . . at last he 'fesses up.
I use ER under 9.4; it works quite well. Relatively low overhead . .
.. . and I'm looking forward to 10.00.
If you don't want to keep Informix in the conversation, then please
drop comp.databases. informix from your post list. Give a hoot, don't
pollute.
JWC This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David Eng |
last post by:
> For many years now enterprise business application development has
> been the core area for the use of C++.
> Today a significant share to this segment has already been lost to
> SUN's Java technology and with MS now abandoning C++ in favour if its
> proprietery .NET and C# technology, how long can we except C++ to hold
> on against these might competitors?
> Has C++ become a dying language?
> What is the future of C++?
As I posted...
|
by: GTO |
last post by:
I do not believe that C# is the future of C++. I also do not believe that
adding two thousand new library functions to the standard library is the
future of C++. But what is the future of C++? Is it as good as a programming
language can get?
Like so many of you, I programmed speech recognizers, image recognition
systems, a portion of a chess program, lots of numeric code using STL, and
tons of other applications in C++, (even firmware...
|
by: Lyle Fairfield |
last post by:
It's confusing. Many people here and elsewhere make many different
predictions:
There's an introduction mentioning some aspects of this at
http://msdn.microsoft.com/data/mdac/techinfo/default.aspx?
pull=/library/en-us/dnmdac/html/data_mdacroadmap.asp
revised Sep 2005
(upper case conversions are mine)
|
by: |
last post by:
Everything seems to be moving to .NET and VC++ seems to be adding a lot of
managed code support every new release.
The questions: is unmanaged code in VC++ beeing phased out in favour of
managed code?
And suppose I still program in VC++ 6.0, can I safely assume that the code I
use in VC++ 6.0 will still be available in future VC++ versions.
Finally will VC++ 6.0 generated executables be still be able to run on futur
Windows versions and...
|
by: Fuzzyman |
last post by:
Hello all,
The following is a copy of a blog entry. It's asking a question about
future statements and the built in compile function. I'd appreciate any
pointers or comments about possible approaches.
`Movable Python <http://www.voidspace.org.uk/python/movpy/>`_ supports
running both Python scripts and ``.pyc`` bytecode files. It does this
by compiling scripts to bytecode, or extracting the code object from
bytecode files, and then...
| |
by: Zootal |
last post by:
My apologies if this gets asked/discussed a lot. With c# rampaging through
corporate USA (and other countries), what impact will this have on the usage
and future of c++? I've used both of them a bit. I'm in school, and our CS
program does not use c#, but uses mostly c++ and a bit of java. C# is
relegated ot the CIS programs. Out there in the real world, what kind of a
future does c++ have?
|
by: rohayre |
last post by:
Im a long time java developer and actually have never done anything
with java scripting. I'd like to write a short simple script for
calculating a date in the future based on today's date and a letter.
Can I use javascripting to create a webpage to allow a user to enter a
letter and then click a button to find a future calendar date? I'm just
not sure how much user interaction scripting allows. Does java
scripting allow buttons, textfields...
|
by: blangela |
last post by:
If you had asked me 5 years ago about the future of C++, I would have
told you that its future was assured for many years to come. Recently,
I have been starting to wonder.
I have been teaching C++ at a local polytechnical school here in
Vancouver, Canada for approximately 8 years. Six years ago, at the
height (or should I say volume?) of the internet bubble, I had 80+
students per semester in my C++ course. Now I am fortunate to have...
|
by: KimmoA |
last post by:
Does C have a future? I'd like to think so, but nobody seems to agree
with me. Of course, I don't use C in my profession, and maybe I
wouldn't be using it if I had the pressure to actually produce things
with deadlines and stuff. Hmm. That's a depressing thought.
I can't stand OOP. Yes, it is beautiful in theory, and it might make
sense for huge projects with many people involved, but I don't want
anything to do with it. (I switched to C...
|
by: Jon Harrop |
last post by:
If Microsoft turn F# into a product and place it alongside C# and VB, will
many people migrate from C# to F#?
--
Dr Jon D Harrop, Flying Frog Consultancy
http://www.ffconsultancy.com/products/?u
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |