Hi Andrew, > [inconsistent data] > The situation with the data is more of a problem however. I don't want > to beat a dead horse here, and I would be > stupid to run this kind of a routine against a live database, for the > fist time. But the crash recovery needs to be consistent. > In my temp table I had two records. I watched both be deleted. One was > recovered. The one that was lost, is really lost. > The records where inserted into a second table. Both where lost. A table > had a columns value updated twice, it recovered this > changed value.
Sigh. Yes, we should address our recovery inconsistencies, unfortunately, this is not a trivial problem. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
