Here's a complet Tom Kyte answer ... http://asktom.oracle.com/pls/ask/f?p...#4118658603057

Data dictionary operations required by the insert will still generate minimal redo of course.