Undo [message #358141] |
Sun, 09 November 2008 03:58 |
abuzayd
Messages: 15 Registered: September 2008 Location: this world
|
Junior Member |
|
|
Hi,
I'm just going through the undo management lesson in the oracle hand book and thought i should practise what was thought. This is the scenario i thought up and practised but it did not work.
I carried out a DML on a table (DELETE jobs_acquisition).
I then stopped the listener and restarted it to try and see if the will roll back the change as i had not committed it, but nothing happened
What action can i carry out to see the effect of the undo please. I'm thinking of shutting down the database (using immediate). Will that be OK?
Please your posts will be of great help. Thank you.
|
|
|