OraFAQ Forum: SQL & PL/SQL » Deferred transaction

Home » SQL & PL/SQL » SQL & PL/SQL » Deferred transaction (Oracle 11g R2)

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

Deferred transaction [message #627935]

Tue, 18 November 2014 03:35

sunil.rajak
Messages: 7
Registered: November 2014
Location: India

Junior Member

how to use deferred transaction to sync remote database(materialized view site) with master database using materialized view.

Report message to a moderator

Re: Deferred transaction [message #627937 is a reply to message #627935]

Tue, 18 November 2014 03:37

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Is this question related to your previous topic http://www.orafaq.com/forum/m/627717/#msg_627717

Report message to a moderator

Re: Deferred transaction [message #627938 is a reply to message #627935]

Tue, 18 November 2014 03:37

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What is "deferred transaction" for you?

Report message to a moderator

Re: Deferred transaction [message #627939 is a reply to message #627937]

Tue, 18 November 2014 03:40

sunil.rajak
Messages: 7
Registered: November 2014
Location: India

Junior Member

Yes it is related with that.

Report message to a moderator

Re: Deferred transaction [message #627940 is a reply to message #627938]

Tue, 18 November 2014 03:41

sunil.rajak
Messages: 7
Registered: November 2014
Location: India

Junior Member

The deferred transactions are stored at the materialized view site so that they can be sent to the master site and applied to master tables.
A refresh of an updatable materialized view first pushes the deferred transactions at the materialized view site to its master site. Then, the data at the master site is pulled down and applied to the materialized view.

Report message to a moderator

Re: Deferred transaction [message #627942 is a reply to message #627940]

Tue, 18 November 2014 03:45

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

You have answered your question! So what is the problem? Is the job broken, for instance? Or are your conflict resolution methods not setup appropriately?

Report message to a moderator

Re: Deferred transaction [message #627945 is a reply to message #627942]

Tue, 18 November 2014 03:50

sunil.rajak
Messages: 7
Registered: November 2014
Location: India

Junior Member

How to configure deferred transaction?

Report message to a moderator

Re: Deferred transaction [message #627955 is a reply to message #627945]

Tue, 18 November 2014 04:26

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

You haven't read the Advanced Replication doc that I pointed you towards in your previous topic, have you? There is a whole chapter on configuring Materialized View replication.

Report message to a moderator

Previous Topic:	compile package - select V$MVREFRESH without user's rights
Next Topic:	please help me in query...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 12:27:07 CDT 2024