What's the NOLOGGING clause for when creating tables? Some of our
tables (particularly intermediate and output set tables) have been
created with the NOLOGGING clause, which I assume means that in the
case of a system failure (crash), these tables won't be recoverable.
This is acceptable, since the process would be restarted anyway once
oracle was restarted. On the plus side, I assume inserts and updates
are faster. Is this generally a good idea and something that people
would recommend in general?

Thanks

Dean