Crazy Idea of Mixing Flashback Data Archive and Editioning


Now that Flashback Data Archive is now included in the base 11.2.0.4 license, I had the crazy idea to mix it with Database Editioning.

Continue reading

Advertisements

Examination of Neil Chandler’s Post about Adding NOT NULL Columns with DEFAULT values


Neil Chandler has a very interesting post about Adding NOT NULL Columns with DEFAULT values which:

From Oracle 11G, if you: ALTER TABLE table ADD ( column col-type DEFAULT def NOT NULL ) the default isn’t actually added to the data. It’s only added to the meta-data.

Continue reading