Home » Server Options » Streams & AQ » UPDATE_CONFLICT_HANDLER
UPDATE_CONFLICT_HANDLER [message #282939] Sun, 25 November 2007 06:45 Go to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
DECLARE
cols DBMS_UTILITY.NAME_ARRAY;
BEGIN
cols(1) := 'a';
cols(2) := 'b';
DBMS_APPLY_ADM.SET_UPDATE_CONFLICT_HANDLER(
object_name => 'sadat.test2',
method_name => 'OVERWRITE',
resolution_column => 'a',
column_list => cols);
END;
/

Is there any procedure by which I can set handler for all objects for a schema???


thanx.

Report message to a moderator

Re: UPDATE_CONFLICT_HANDLER [message #283093 is a reply to message #282939] Mon, 26 November 2007 01:44 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
I think it is not possible.

Report message to a moderator

Re: UPDATE_CONFLICT_HANDLER [message #283103 is a reply to message #282939] Mon, 26 November 2007 02:12 Go to previous message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
I appreciate ur thinking.

Report message to a moderator

Previous Topic: downstream replication problem
Next Topic: Remove apply rule
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Aug 19 00:53:07 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.