A method and apparatus for updating databases are disclosed. In response
to a flashback request, a database object is restored to a state as of a
specified flashback time. The changes introduced into the database object
are reversed in a sequence starting with a change introduced into the
database object immediately before issuance of the flashback request and
ending with a change introduced into the database object immediately
after the specified flashback time.