Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Currently in Delaware, US.

    Unanswered: Reverting back the data after processing


    I have several tables in a DB with numerous rows of data. I run a process, which modifies some of the rows in some tables and commits the transaction. Now I want to revert the tables back to the original state as they were before running the process.

    Is it possible without backing up the tables before running the process, because it will occupy a lot of tablespace.


  2. #2
    Join Date
    Aug 2003
    SW Ohio

    Re: Reverting back the data after processing

    COMMIT; means you are satisfied with the results of your processing!

    But I take you are doing testing, or something similar. Probably your best bet is to create some kind of backup table and put a trigger on your primary tables to do a before update/delete into your backup tables.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts