Re: Conflict Resolution

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Mon, 15 Feb 1999 10:44:15 -0800
Message-ID: <36C86AFF.4BDBF8B4@us.oracle.com>

Praveen

Comments after each question.

HTH Pete

pgaur_at_cdotd.ernet.in wrote:

> Hi , Wanted some emergency solutions to following : 1. Is it necessary to
> assign coloumn to column groups?

Depends on what you want to do as far as conflict resolution is concerned. From the flow of your questions, I'd say yes, but remember Oracle creates a "shadow" column group to contain all the columns you don't specifically group. Hence it's not really "necessary" to assign columns to column groups.

> 2. Does Oracle of itself have any conflict
> resolution strategy?

There are 8 built in resolution strategies (latest / earliest timestamp etc.). Oracle can't decide which to use in any given situation, so you have to specify which one you want to use, or write your own and specify that.

> 3. If we have more than two masters(in multi master
> configuration), what is the best conflict resolution strategy?

As you get past two masters, the provided options that can be used lessen. Generally, clients I've seen using more than two masters use a combination of latest timestamp (primary) and site priority (secondary, in case of ties in the latest timestamp method). That's not saying this is the "best" strategy to use though. Very dependent on your requirements.

> 4. For latest
> timestamp Conflict Resolution Strategy, is it necessary to have a Date Column
> in the table??

Yes, you must have a date column, plus a trigger to populate this column (usually).

>
>
> Its an urgency here to find out the solutions of above problems.
> Please help out !!
> Thanx
> Praveen Gaur
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Mon Feb 15 1999 - 12:44:15 CST