Thread

  1. Rollback deletes

    Oleg Lebedev <oleg.lebedev@waterford.org> — 2002-10-23T18:36:52Z

    Can anybody point me to docs explaining how to rollback recent
    transactions. 
    Is it possible to rollback recent deletions only? 
    Can I specify the point in time to which I want to rollback?
    Thanks.
     
    Oleg
    
  2. Re: Rollback deletes

    Doug McNaught <doug@wireboard.com> — 2002-10-23T18:43:37Z

    "Oleg Lebedev" <oleg.lebedev@waterford.org> writes:
    
    > Can anybody point me to docs explaining how to rollback recent
    > transactions. 
    > Is it possible to rollback recent deletions only? 
    > Can I specify the point in time to which I want to rollback?
    
    Currently, you can roll back a transaction that is open (not
    committed) using the ROLLBACK statement.  Once you COMMIT, you can't
    "undo" a transaction (unless you wipe out the database and restore
    from a backup, or manually reverse all the changes you made).
    
    -Doug