Hi DBAs,

How does a commit ensures that 'Committed Data' is available when a database
is reopened after crash ?

Bcoz commit only ensures that data is written to Redo logs & not to data
files !!

Kindly help.

Regards
Deepak Kulkarni
Sr. Software Engineer
> CyberTech Systems and Software Ltd.
> B-65, CyberTech House, J B Sawant Marg,
> Rd. No. 21, Wagle Estate, Thane 400 604.
> Call: 583 46 43/44/45 Extn 2241
> ===============================================
> "No major application will run in Third Normal Form"
> George Koch --- ORACLE8 : The complete
> Reference
> ===============================================
>
>
>
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002

Oracle LazyDBA home page