For those not familiar with Richard Foote’s extensive blog about indexes (and if you’re not you should be) – the title of this note is a blatant hi-jacking of his preferred naming mechanism.

It’s just a short note to remind myself (and my readers) that anything you know about Oracle, and anything published on the Internet – even by Oracle Corp. and its employees – is subject to change without notice (and sometimes without being noticed). I came across one such change today while read the Expert Oracle Exadatabook by Kerry Osborne, Randy Johnson and Tanel Poder. It was just a little throwaway comment to the effect that:

The obvious error there is the reference to “index REBUILD”. Although create table as select and alter table movedefault to nologging (when running in noarchivelog mode) the equivalent commands for indexes have always been logged. On the other hand, pausing for thought here, I wouldn’t expect such an obvious error to slip past all three authors and the technical reviewers so, before opening my mouth and putting my foot firmly into it, I decided to run a quick test and, almost inevitably, I have a handy test script that I’ve been running intermittently for years for exactly this test case.

Jonathan Lewis is a well-known figure in the Oracle world with more than 26 years experience using the software. He has published three books about Oracle, and contributed to three others. His most recent book Oracle Core: (Apress, ISBN 978-1430239543) is a description of the central working of the Oracle database engine.
He runs a couple of websites and contributes fairly regularly to newsgroups, forums, and User Group magazines and events around the world.