How to get snapshot on a moment of a table where continuous updating happen
587887Jul 13 2007 — edited Jul 16 2007we have an online oracle database having 7 mil row in one table with 50+ column. We need to take snapshot of the table with 7 columns at any moment. Currently we are trying to do it by select statement. Select statement takes about one hour to complete; we get first record with the value at statement execution start time lets say at 12:00 am and the last record with the changed value by the time at 1:00 am. We need all record having value at 12:00 am
The database is high volume transaction processing database. Every second, thousands of records are being updated in the target table. We have to capture the snapshot of the table at command execution start time without hampering online transaction as the target table is the core customer credit table of telecom billing. There are 7 million records in the table and in hour, about 200K records being updated.
how we can get snapshot of that table