sequence no higher than other [message #433876] |
Fri, 04 December 2009 13:24  |
tannad
Messages: 43 Registered: January 2008 Location: mumbai
|
Member |
|
|
HI,
We need to verify that sequences last number in one primary db is higher than on failover db after failing back to primary db
Suppose
LAR@PRIDB -- primary db
MAY@FALDB -- failover db
and there are 70 sequences like ABC_SEQ.. CBA_SEQ
how to check last number in one primary db is higher than on failover db
|
|
|
|
Re: sequence no higher than other [message #433879 is a reply to message #433876] |
Fri, 04 December 2009 13:44  |
tannad
Messages: 43 Registered: January 2008 Location: mumbai
|
Member |
|
|
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
|
|
|