{"id":73315,"date":"2012-05-29T11:13:26","date_gmt":"2012-05-29T11:13:26","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/uncategorized\/ch-ch-ch-ch-changes\/"},"modified":"2021-07-14T13:07:57","modified_gmt":"2021-07-14T13:07:57","slug":"ch-ch-ch-ch-changes","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/ch-ch-ch-ch-changes\/","title":{"rendered":"Ch-ch-ch-ch-changes"},"content":{"rendered":"<p>For those not familiar with\u00a0<a href=\"http:\/\/richardfoote.wordpress.com\/\" target=\"blank\">Richard Foote\u2019s extensive blog<\/a>\u00a0about indexes (and if you\u2019re not you should be) \u2013 the title of this note is a blatant hi-jacking of his preferred naming mechanism.<\/p>\n<p>It\u2019s just a short note to remind myself (and my readers) that anything you know about Oracle, and anything published on the Internet \u2013 even by Oracle Corp. and its employees \u2013 is subject to change without notice (and sometimes without being noticed). I came across one such change today while read the\u00a0<a href=\"http:\/\/www.amazon.com\/Expert-Oracle-Exadata-Kerry-Osborne\/dp\/1430233923\" target=\"blank\">Expert Oracle Exadata<\/a>book by Kerry Osborne, Randy Johnson and Tanel Poder. It was just a little throwaway comment to the effect that:<\/p>\n<p><em>In NOARCHIVELOG mode all bulk operations (such as INSERT, APPEND, index REBUILD and ALTER TABLE MOVE) are automatically nologging.<\/em><\/p>\n<p>The obvious error there is the reference to \u201cindex REBUILD\u201d. Although\u00a0<em><strong>create table as select<\/strong><\/em>\u00a0and\u00a0<em><strong>alter table move<\/strong>\u00a0<\/em>default to nologging (when running in\u00a0<strong>noarchivelog<\/strong>\u00a0mode) the equivalent commands for indexes have always been logged. On the other hand, pausing for thought here,\u00a0I wouldn\u2019t 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\u2019ve been running intermittently for years for exactly this test case.<\/p>\n<p>Read the fullpost on my <a href=\"http:\/\/jonathanlewis.wordpress.com\/2012\/05\/28\/ch-ch-ch-ch-changes\/\" target=\"blank\">blog<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For those not familiar with\u00a0Richard Foote\u2019s extensive blog\u00a0about indexes (and if you\u2019re not you should be) \u2013 the title of this note is a blatant hi-jacking of his preferred naming mechanism. It\u2019s just a short note to remind myself (and my readers) that anything you know about Oracle, and anything published on the Internet \u2013 even by Oracle Corp. and&hellip;<\/p>\n","protected":false},"author":101205,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143533],"tags":[],"coauthors":[],"class_list":["post-73315","post","type-post","status-publish","format-standard","hentry","category-oracle-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/101205"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=73315"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73315\/revisions"}],"predecessor-version":[{"id":91764,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73315\/revisions\/91764"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=73315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=73315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=73315"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=73315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}