US 6,983,286 B1
Method and apparatus for accessing data as it existed at a previous point in time
Bipul Sinha, Foster City, Calif. (US); Namit Jain, Foster City, Calif. (US); Amit Ganesh, San Jose, Calif. (US); Archna Kalra Johnson, Sunnyvale, Calif. (US); and Srinivas Vemuri, Foster City, Calif. (US)
Assigned to Oracle International Corporation, Redwood Shores, Calif. (US)
Filed on Dec. 18, 2002, as Appl. No. 10/325,211.
Claims priority of provisional application 60/378016, filed on May 10, 2002.
Int. Cl. G06F 17/30 (2006.01)
U.S. Cl. 707—102 26 Claims
OG exemplary drawing
 
1. A computer-implemented method for processing flashback queries, the method comprising the steps of:
receiving a flashback query;
determining a flashback time associated with said flashback query;
determining whether the flashback query satisfies a set of conditions relative to a flashback cursor that was created prior to receipt of said flashback query;
wherein one condition in said set of conditions is that the flashback time associated with the flashback query satisfies a condition relative to a time period associated with the flashback cursor; and
if the flashback query satisfies said set of conditions relative to said flashback cursor, then using the flashback cursor to process said flashback query.