I am adding entries into my database soon, this does not happen often at my place of work. I would like to make sure that in the event that the data entry does not go to plan I can rollback my database to a previous state (now).
Do I have to do anything beforehand to make this possible? How do I preform a rollback if it is necessary?
I am using oracle 8.1 and windows 2000 server.