Finding the difference of 2 DB snapshots -
07-24-2004
, 10:14 AM
Our application which is running on a Sun Solaris system, uses an
Oracle database, containing lot of tables and millions of records
within it.
We will call the state of this database at time=t1, as snapshot-1.
Assume that, the state of the database is changed during the
Application run for a certain period of time. We call this state at
t2 as snapshot-2.
What is the best way of getting the difference between these 2
snapshots?
Basically, we have a requirement to get the database commands which
were executed between t2 and t1, and execute the same set in a
different Sun Solaris system. |