Home » SQL & PL/SQL » SQL & PL/SQL » What happens to data in case of improper shutdown if we have not committed it.
icon5.gif  What happens to data in case of improper shutdown if we have not committed it. [message #194473] Fri, 22 September 2006 05:56 Go to next message
Bhupinder1
Messages: 2
Registered: September 2006
Location: New Delhi
Junior Member

Hi all,

What would be state of data in the database if we have improper shutdown. Like if we have run few DML statements and have not done commit, and if we shut down the system. Is this data that was not committed, be recovered next time we login. Also how exactly is all this done.

If anyone can explain me this procedure.

Regards,
Bhupinder;
Re: What happens to data in case of improper shutdown if we have not committed it. [message #194484 is a reply to message #194473] Fri, 22 September 2006 06:25 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
hi first of all you can obtain all the information by clicking here
1)If we have an improper shutdown the awaiting transactions are not committed.
2)We cannot retrieve the information once we shutdown.

but is we do proper shutdown using the EXIT command all the waiting transactions are saved when you exit.
Previous Topic: Idea pls
Next Topic: Deleting database
Goto Forum:
  


Current Time: Thu Dec 08 20:05:36 CST 2016

Total time taken to generate the page: 0.09588 seconds