| plz. clarify [message #64175] |
Mon, 27 December 2004 20:13  |
Jagdish
Messages: 43
Registered: September 2003
|
Member |
|
|
Experts,
I am new to oracle db. When i try to do dml operations, if the power shut down occurs, will the operations committed to database. If not why? if yes why?
Regards
Jagdish
|
|
|
|
| Re: plz. clarify [message #64180 is a reply to message #64175] |
Tue, 28 December 2004 01:16  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
If the power goes down changes that are not explicitly committed will be rolled back when you restart the DB. Point is, it you don't say COMMIT; the data is not (and should not be) committed.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
