|In stream replication sequence# is not being replicated [message #361924]
|Fri, 28 November 2008 10:30
Registered: February 2008
Using Oracle 10g 10.2.0.3.0 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