Crazy Idea of Mixing Flashback Data Archive and Editioning

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

Continue reading


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