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.
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.