OraFAQ Forum: Replication » What does "WITH SEQUENCE" clause in "CREATE SNAPSHOT LOG" statement do?

Home » Server Options » Replication » What does "WITH SEQUENCE" clause in "CREATE SNAPSHOT LOG" statement do?

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

What does "WITH SEQUENCE" clause in "CREATE SNAPSHOT LOG" statement do? [message #376695]

Thu, 18 December 2008 05:19

rizimazhar
Messages: 34
Registered: August 2008
Location: Pakistan

Member

Since i had mix of INSERT/UPDATE/DELETE operations with my materialized view, so I had a little issue with the execution seuqnce as mentioned earlier.

Can anybody tell me exactly what is the function of WITH SEQUENCE clause in CREATE SNAPSHOT LOG statement.

[TOPIC SPLIT by LF]

[Updated on: Thu, 18 December 2008 13:44] by Moderator

Report message to a moderator

Re: snapshot refresh order, can we perform in order [message #376723 is a reply to message #376695]

Thu, 18 December 2008 06:39

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

Don't start new topic from existing thread.

Babu

Report message to a moderator

Re: snapshot refresh order, can we perform in order [message #376727 is a reply to message #376695]

Thu, 18 December 2008 06:41

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Reported By: gentlebabu On: Thu, 18 December 2008 13:40 In: Server Options � Replication � snapshot refresh order, can we perform in order
Reason Hello, Please chk this thread. Requesting to you lock this topic. Thank you in advance. Babu

Don't report message to get attention.
Read forum guide, it is said this is not allowed and even counter-productive.

Regards
Michel

Report message to a moderator

Re: snapshot refresh order, can we perform in order [message #376729 is a reply to message #376727]

Thu, 18 December 2008 06:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Michel,

I believe you got it wrong: @gentlebabu is warning @rizimazhar not to ask questions which are not related to the original problem into the same topic.

In other words, I think that he'd like moderators to split this topic (i.e. message dated Thu, 18 December 2008 12:19 CET). OK, he wanted this topic to be locked, but I wouldn't want to do that.

Split - yes.
Lock - no.

Or, did I misunderstood the problem? If so, could you, @gentlebabu, explain it once again, please?

Report message to a moderator

Re: snapshot refresh order, can we perform in order [message #376824 is a reply to message #376729]

Thu, 18 December 2008 13:21

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello Mr.Michel & Mr.Littlefoot,

>>Re: snapshot refresh order, can we perform in order

ASAIK This thread only started for analyzing snapshot refresh order only.

But recent post NOT related to subject.

Quote:

I believe it's NOT related to subject.

My Mistake I need to suggested to Mr.rizimazhar create new topic for posting query's also mistakenly used 'LOCK' word.

This topic should be split not LOCK.

Thank you in advance.

Babu

Report message to a moderator

Re: snapshot refresh order, can we perform in order [message #376896 is a reply to message #376729]

Fri, 19 December 2008 01:11

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry, I indeed misunderstood the reporting message.
Thanks for correcting.

What is ASAIK?

Regards
Michel

Report message to a moderator

Re: snapshot refresh order, can we perform in order [message #376918 is a reply to message #376896]

Fri, 19 December 2008 03:02

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Sorry for using IM-Speak.

Thanks for catching.

>>What is ASAIK? – I guess As per As I know.

@rizimazhar;

Check Here

Babu

[Updated on: Fri, 19 December 2008 03:05]

Report message to a moderator

Previous Topic:	snapshot refresh order, can we perform in order
Next Topic:	ORA-06502 in DBMS_RECTIFIER_DIFF.DIFFERENCES

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 11:31:21 CST 2024