We are planning to implement Active-Active solution , by the below methodology ..
- Site A: All the table’s primary key (ID column) can start with ODD numbers
- Site B: All the table’s primary key (ID column) can start with EVEN numbers
Need to find out the below in our DB env,
- The list of tables which are not using the sequences… ( So we can further analyze how their primary key values are getting populated )
- Also list out the tables with their corresponding sequence.
Quick help on this is much appreciated
Thanks in advance
Kenny