Home » Server Options » Streams & AQ » In stream replication sequence# is not being replicated ( on linux 64 bit)
In stream replication sequence# is not being replicated [message #361924] Fri, 28 November 2008 10:30
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member

Using Oracle 10g on linux 64 bit

I am using one way schema stream replication from production to destination server, it is working fine but i am also using stream replication for disaster recovery, problem is that all sequence object's Next number in destination server are still 1 whereas in Production next number has increased.

So my question is when i am replicating schema and sequences of same schema are not identical in destination server, what will i do when i use destination server in disaster recovery . Do i need to check the maximum number of each table and create sequence again in destination server or is there any solution for this.

Can i create a script which i can run to set the next value of all sequence object accordning to there corresponding tables sequence field

[Updated on: Fri, 28 November 2008 10:57]

Report message to a moderator

Previous Topic: In one way stream replication, do i need to disable function,trigger and proc on destination
Next Topic: Steps to use destination server as production
Goto Forum:

Current Time: Sun Jun 23 13:26:56 CDT 2024