| In stream replication sequence# is not being replicated [message #361924] |
Fri, 28 November 2008 10:30 |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
Hi,
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
