Home » Other » Training & Certification » Undo (Oracle 10g, Release 2)
Undo [message #358141] Sun, 09 November 2008 03:58 Go to previous message
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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Oracle Architecture
Next Topic: plsql topics
Goto Forum:
  


Current Time: Fri Apr 19 21:51:14 CDT 2024